| Home |
| Search |
| Today's Posts |
|
#3
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. |
| 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) | |||
Threaded Mode
