| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing last column's letter
A pesky little thing is eluding me. If I determine that the last used column
in a worksheet is, say, Worksheet.Columns(22), how can I convert that into "V" so I can subsequently do things to Cell V1? I'm sure there must be some nifty Property out there somewhere for this purpose, but darn if I've been able to find it. Surely this isn't going to take some gawdawful Select Case statement! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I invert a column's contents | Excel Worksheet Functions | |||
| Moving between a column's cells | Excel Programming | |||
| Setting one Column's Value Based On Another Column | Excel Programming | |||
| changing column's order | Charts and Charting in Excel | |||
| Hiding Rows and column's | Excel Programming | |||
Threaded Mode
