| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying the column letter
Below is a code that Tom Olgilvy game me. It puts certain
values in a vertical range starting in cell Y4. What I would like in addition is for it to put the actual column letter of the corresponding value in column X startin gwith cell 4. Sub Copy9th() Set rng = Range("AA3") Set rng1 = Range("Y4") For i = 0 To 25 rng1.Offset(i, 0).Value = _ rng.Offset(0, i * 9).Value Next End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
| Column Chart, Displaying two values on one column. | Charts and Charting in Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Threaded Mode
