Reference Column by #?
You're close:
Worksheets("Sheet1").Cells(1, 75).Value = blahblah
And you can use variables in place of the numbers.
C = 75
Worksheets("Sheet1").Cells(1, C).Value = blahblah
--
Hmm...they have the Internet on COMPUTERS now!
"HotRod" wrote:
Can I reference a worksheet cell by # instead of A75 use (1, 75) or
something similar?
What is the format?
Worksheets("Sheet1").Range(1, 75).Value = ???
|