Selecting all contents on page (range)

[andycharger]

I need to know how I select all the used cells on a page and set it to
range

I remember something about A1, End(XLDown) or something.

Can anyone help please

 

[Frank Kabel]

Hi
dim rng as range
set rng = activesheet.usedrange