I am attempting to find a way to manipulate a cell reference of a variable. I was imagining using a variable as a range and adjust what that range is, but I have had absolutely no luck making that work.
Specifically this is an example of what I want to do:
Dim CellLocation as Range
Set CellLocation = Range("A1")
Now I want to be able to add/subtract from the current row/column so that I can change the cell reference. Let's say I wanted to be able to make it A2 without hard-coding it. So that every time the procedure is run, it moves down a row.
I hope that I have explained that well. Maybe I need to make it something besides a range? I have been learning VBA for about 2 weeks now with no prior programming experience, so I am having a little trouble with simple things like this...
Bookmarks