Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Column by #?
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 = ??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Column by #?
If finding it difficult to jump from Coulmn "Z" to "AA" when I need to.
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Column by #?
Never mind I found
Worksheets("Sheet1").Cells(30, 30).Value = |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 = ??? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Column by #?
I don't understand what you mean? The code below works just fine for me:
Sub Test() Dim objRG As Range Set objRG = ActiveWorkbook.ActiveSheet.Cells(1, 35) MsgBox objRG.Address Set objRG = Nothing End Sub It get a message box of AI1. -- Hmm...they have the Internet on COMPUTERS now! "HotRod" wrote: If finding it difficult to jump from Coulmn "Z" to "AA" when I need to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - changing column reference based on value of other column | Excel Discussion (Misc queries) | |||
MS Excel - changing reference column value based on another column | Excel Discussion (Misc queries) | |||
Excel - changing column reference based on value of other column | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |