View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
MDW MDW is offline
external usenet poster
 
Posts: 117
Default 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 = ???