I would like to accomplish this:
#1) Set DataColumn = Range("D24:D41")
with something like this:
#2) Set DataColumn = Range(Cells(R0 + 1), Cells(R0 + Fixedn))
#1 works, #2 does not work.
where R0 and Fixedn contain integer values. I want to make this change is because the range of cells differs from time to time.
I tried the following, but it doesn't work either.
Code
With Worksheets("samplingplan")
Set DataColumn = .Range(.Cells(R0 + 1), .Cells(R0 + Fixedn))
End With
DataColumn.ClearContents
How can I fix this?