Help, help, help. I'm driving myself crazy!
I have a table of data which several people use.
I have developed a process to add rows of data at the bottom of the table.
If the table is left filtered by the last user, the code that I use to select the next row does not work.
(I know there are work-arounds, such as ShowAllData, or remove autofiltermode. I would like to know if there is a way to do it without resorting to that, though, keeping the integrity of the filter.)
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select
works fine if the filter is set to show all data.
However, if the data is fitered, it will obviously only work if the bottom row is included in the filter.
I have tried the following:
but that just returns an application or object defined error
I have also tried:
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).SpecialCells(xlCellTypeVisible).Select
. That, however, selects all cells EXCEPT for the filtered cells
I am missing something obvious, perhaps. Can't see the wood for the trees.
Sample table attached
Thanks very much