Selecting all contents on page (range)
 

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

--
Message posted from http://www.ExcelForum.com

Selecting all contents on page (range)
 

Hi
dim rng as range
set rng = activesheet.usedrange

--
Regards
Frank Kabel
Frankfurt, Germany


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

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

Can anyone help please?


---
Message posted from http://www.ExcelForum.com/