How to Dim a variable as a Cell?
On Excel, I'm trying to code a macro that involves selecting a range of cells, in which both the upper limit and the lower limit cells in the range are variables. How would I go about programming this?
On Excel, I'm trying to code a macro that involves selecting a range of cells, in which both the upper limit and the lower limit cells in the range are variables. How would I go about programming this?
garbo7441
Favorite Answer
What defines the variables you wish to assign to your range of cells? Last Row? Last Column? Or...?
nobody
Sub YourSubName(variableName as Range)
End Sub