Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells.find only reporting range in AutoFilter...
Years ago, someone here recommended that I use this to find the intersection
of the last used row and column, independant of whether data had been deleted since the last save, etc: reallastrow = Cells.Find("*", Range("A1"), xlFormulas, , xlByRows, xlPrevious).Row reallastcol = Cells.Find("*", Range("A1"), xlFormulas, , xlByColumns, xlPrevious).Column I've just discovered that the reallastcol part doesn't work if an AutoFilter is turned on. Instead of the last used column in the worksheet, it reports the last used column in the autofilter, ignoring the fact that columns may be used to the right of the autofilter. Suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to find a range of cells = to a value | Excel Worksheet Functions | |||
autofilter is hiding cells outisde of the range I am trying to fil | Excel Discussion (Misc queries) | |||
Error proof way to find first blank Row after Autofilter Range | Excel Programming | |||
Find a range of values in a range of cells | Excel Worksheet Functions | |||
Reporting of Empty Cells | Excel Worksheet Functions |