I seem to be having a problem with selecting or maneuvering cells on an excel worksheet that is filtered. I am using a code like: ActiveCell.Offset(rowOffset:=3, columnOffset:=3).Activate
What I need is for it to move around the visible cells and not the invisible ones. This code results in activating the third column but, my rows are filtered so it does not go three down. It only goes three over. It is applying to the row numbers and they are not in numerical order because of the filtering.
If anyone knows of a way to do this, or if there is even a way, please let me know! Thank you very much.
- Chris Parent