Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extra rows with no data
Hi. I am using the following line to select a range from
the active cell down to the last cell in the file. My problem is that I want this to go to the last cell THAT HAS DATA. There are several rows below this last cell that are somehow recognized as being part of the range. Is there either a way to delete the rows or to instruct the macro to go to the last cell with data? Range(Selection, ActiveCell.SpecialCells (xlLastCell)).Select Thanks, Mike. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extra rows with no data
Mike wrote:
My problem is that I want this to go to the last cell THAT HAS DATA. There are several rows below this last cell that are somehow recognized as being part of the range. Is there either a way to delete the rows or to instruct the macro to go to the last cell with data? Range(Selection, ActiveCell.SpecialCells (xlLastCell)).Select Try: Range(Selection, ActiveSheet.UsedRange.SpecialCells (xlLastCell)).Select Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change my data or add extra rows in a Pivot Table for Ex. | Excel Discussion (Misc queries) | |||
get rid of extra rows | New Users to Excel | |||
Macro/Formula to extra data from certain rows | Excel Discussion (Misc queries) | |||
Why the extra rows?? | Excel Discussion (Misc queries) | |||
how do I get rid of extra rows | Excel Discussion (Misc queries) |