I was wondering if there was a way to store a cell's location to variables.
Something like:
I'm currently working with a fairly large worksheet, and I'm using Cells.Find to look for a specific cell. Then I want to Filter that column, but I can't figure out what column Selection.AutoFilter Field:=?? should be.![]()
int a, b Cell(a, b) = ActiveCell
Any suggestions?
Bookmarks