View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick[_11_] Rick[_11_] is offline
external usenet poster
 
Posts: 18
Default Copying a block of data

Hi,
How do I write a macro to select a variable cell range so
that I can copy the block of data elsewhere.
e.g. My data range is A3:A18
Sometimes I have data in cells A3:A6 or A3:A10 etc. It
varies.

I only wish to select the block that contains data,
eleiminating the blank cells. End down takes me to the row
A18, regardless whether or not some of the cells have data
in them.

Could anyone assist please,
Thanks