Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete last row in Macro
Hi I am running a Macro which filter out data into a new sheet and then performs a series of functions and then Autofills them down the active cells which vary each time the file is downloaded. When I hit Control + End, I am left with one blank row every time and I need to delete this row. Can anyone give me the code to delete the empty row. Thanks Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=512186 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete last row in Macro
You can't delete it, but you can reset the pointer. See
http://www.contextures.com/xlfaqApp.html#Unused -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Shirley Munro" wrote in message news:Shirley.Munro.237vny_1139916605.0915@excelfor um-nospam.com... Hi I am running a Macro which filter out data into a new sheet and then performs a series of functions and then Autofills them down the active cells which vary each time the file is downloaded. When I hit Control + End, I am left with one blank row every time and I need to delete this row. Can anyone give me the code to delete the empty row. Thanks Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=512186 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming |