When you say blank, do you mean empty or is there a formula in there
returning an empty string. If the cell is truly empty, I don't
understand why it wouldn't work. Just for kicks, try selecting and
deleting the first "blank" cell below your filled cells and then run
the macro again. If that works, it should be able to point one of the
more experienced programmers here in the right direction.



Random


On Sun, 17 Aug 2003 06:35:32 -0700, "Rick"
wrote:

Thanks Random,
Tried that, but no go. I've done the same thing with macro
recorder but same result. It just selects A3:A18......the
whole block. Always start on A3 and data is all
continuous. I just want the data only. Back to square one.
Very frustrating!
Cheers


-----Original Message-----
If you are always starting on A3 and the data is all
continuous (no
blank cells between values), then this should work for
you. I used
the macro recorder to get it.

Range("A3").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy

Random

On Sun, 17 Aug 2003 06:03:56 -0700, "Rick"

wrote:

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

.