Use END to select range with data with a Macro?

[Cosmos75]

I have a range with data in range A1:H20. I am trying to make a macro which will select this range which may have rows added to it, but never columns added to it. (i.e, it’ll always start with A1 and end with column H, but the last row may changes).

Is there a way to write a marco to do this? And then once it’s selected that range, I want to be able to Copy it or Make it the Print Area.

THANKS!

 

[Barrie Davidson]

On 2002-03-06 14:05, Cosmos75 wrote:
I have a range with data in range A1:H20. I am trying to make a macro which will select this range which may have rows added to it, but never columns added to it. (i.e, it’ll always start with A1 and end with column H, but the last row may changes).

Is there a way to write a marco to do this? And then once it’s selected that range, I want to be able to Copy it or Make it the Print Area.

THANKS!

This will copy the range:

Range("A1", Range("H65536").End(xlUp).Address).Copy

You'll just have to put in where you want to paste it. You can use variations of that to select and/or set print area.

Hope this helps,