Hi,

Try this

Range("A1:B" & Range("B6").End(xlUp).Row).Copy

Note B6 isn't a typo, this works for A1 - B5

Mike

"ramzi" wrote:

HI...

my data range area is from A1:B5.....
How I going to copy only the range with data... ( my range of data keep on
changing but within A1:B5.

e.g the data is located at A1:B2, so the macro will ignore A3:B5.

rgds