set rng = cells(rows.count,"E").End(xlup)

--
Regads,
Tom Ogilvy

"sa02000" wrote in
message ...

Lets say I have 100 rows and 5 columns (upto E column) of data in a
spreadsheet. What will be the best way to get the location of last cell
in the spread-sheet (in this case E100) so that I can use row and column
variables. I would like to use those when I want to write a formula in
one cell and copy that along the column or do a selection etc.

Thanks,
Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile:
http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=472569