Selecting Just Data
 

I'm sure this is fairly simple but I'm pretty much a newbie to VB
programming in excel!

I need some code which will select just the data I have in a s/sheet so
I can then copy and paste it wherever I wish. At the moment I am just
picking up the first 500 rows which means I'm pasting lots of blank
cells!

Thanks for any help:)


--
mr starface
------------------------------------------------------------------------
mr starface's Profile: http://www.excelforum.com/member.php...o&userid=30520
View this thread: http://www.excelforum.com/showthread...hreadid=558701

Selecting Just Data
 

Take a look at the "SpecialCells" method in vba help.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"mr starface"
wrote in message
I'm sure this is fairly simple but I'm pretty much a newbie to VB
programming in excel!
I need some code which will select just the data I have in a s/sheet so
I can then copy and paste it wherever I wish. At the moment I am just
picking up the first 500 rows which means I'm pasting lots of blank
cells!
Thanks for any help:)--
mr starface