| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - loop columns named AA, AB..etc
Hello
I have a problem, I am looping through this sequence of columns, see below, in order to change my list into a list more suited for pivottables; everything worked fine until now, when i also have columns AA,AB... until AO. If I just write them after column z (the z in the string) it will take three A:s then a B then A then C etc.... How can I fix this (... For i = 3 To 2 ThisCol = Mid("ABCDEFGHIJKLMNOPQRSTUVWXYZ", i, 1 (...) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to use Lookup with Named Columns | Excel Worksheet Functions | |||
| How can I sum data on a row from certain named columns? | Excel Worksheet Functions | |||
| loop over columns | Excel Discussion (Misc queries) | |||
| Loop through ranges columns | Excel Programming | |||
| How do I delete rows and columns in With With End Loop? | Excel Programming | |||
![Tobias[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
