Copy Until Blank

A

Alec

I have a sheet where the number of rows may vary in a
range, I need to copy this range to another sheet. But I
cannot find any function that will give me the first empty
row in a range, or empty cell in a column.

Any help would be appreciated.

Thanks
Alec
 
A

Alec

Thanks for your reply Mike:

However I do not want to copy the whole used range, but a
number columns within that range.
 
D

Don Guillett

Does this help?

x=cells(65536,"a").end(xldown).row
y=cells(1,"IV").end(xltoright).column
 
A

Alec

Thanks Don;

The End statement works fine.



-----Original Message-----

Does this help?

x=cells(65536,"a").end(xldown).row
y=cells(1,"IV").end(xltoright).column




.
Click to expand...
 
Top