I am using Excel to open up an html file from which I then need to
delete various rows and columns. It is always the first 3 rows and
first column. I must always delete the last 4 row and last 2 columns
but the actual row numbers and column letters can vary depending on how
many rows and columns are contained in the html file. I can use
Ctrl+end to go the last cell but this could vary each time the html
file is downloaded. Can anyone tell me the code which would cause a
macro to go to the last cell being used and delete 4 rows and 2 columns
from here.

Thanks

Shirley


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=401070