Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro not consistant
I'm using these statements in some macros:
lc = Cells(1, Columns.Count).End(xlToLeft).Column lr = Cells(Rows.Count, lc).End(xlUp).Row Range(Cells(1, 1), Cells(lr, lc)).Select Most of the time they work but some of the time they do not select all the rows leaving out one or two. Anyone know why? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |