UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

invokes Excel Gurus	by postaljohn	2007-05-18 11:08:35
Calucated Values	by Baywolfe	2007-05-18 11:57:39
I've done the copy and paste special	by postaljohn	2007-05-18 12:05:14
Do this.	by lheggland	2007-05-18 12:15:40
Range("B4").Select 'Select the cell to be copied. Selection.Copy Sheets("Sheet2").Select 'Select the destination. Range("B2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False 'Paste it. Make a button for this or use the cell updated event. Also you can cange the Range statment to Cells(xlRow,xlColumn).Select I like that better because you are working with integers vice a string.
[ Reply ]
Thanks, I'll give it a try tonight! (n/t)	by postaljohn	2007-05-18 12:19:51

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)