Macro Help

[Sunvisor]

How do I adjust my macro to only copy a specific range until the column is blank...

Lets say my range is A5:H20

But rows in any other column than A can be blank...Column A can not!!

 

[VoG]

Try

LR = Range("A" & Rows.Count).End(xlUp).Row
Range("A5:H" & LR).Copy

 

[repairman615]

Hello,

Try:

<font face=Courier New>Range(Cells(1, 1), Cells(20, Range("A1").End(xlToRight).Column)).Select</FONT>

 

[Sunvisor]

Thanks VOG, that's perfect