Hi all,
I'm writing code to clear the contents of a range of cells. The tricky part is that the range depends on a variable. I want the code below to clear the contents of a range from column "CAR" row 3. My starting example is:
Dim CAR as double
CAR = Sheet1.cells(1,1).value
Sheet1.Range(????, "H20").ClearContents
Any ideas how I should write the first range perameter to refer to the variable as a column?
Thanks!
Kelsey
I'm writing code to clear the contents of a range of cells. The tricky part is that the range depends on a variable. I want the code below to clear the contents of a range from column "CAR" row 3. My starting example is:
Dim CAR as double
CAR = Sheet1.cells(1,1).value
Sheet1.Range(????, "H20").ClearContents
Any ideas how I should write the first range perameter to refer to the variable as a column?
Thanks!
Kelsey