| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
R1C1 versus A1 in VB code
Debug.Print Selection.SpecialCells(xlCellTypeLastCell).Column produces a
column NUMBER. How do I get back instead, or convert that to, the letter portion of the column label in A1 format? e.g. the last active cell is "Z42" The above code returns 26. I need it to return "Z". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
| Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Discussion (Misc queries) | |||
| R1C1 versus A1 | New Users to Excel | |||
| What's wrong with this code (r1c1 paste) | Excel Programming | |||
| Converting code to R1C1 format | Excel Programming | |||
![Bill Sturdevant[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
