Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
column loop
How can I change the column charater in a loop for the following:
If iKN = 1 Then Set CellRangePMR = Worksheets("PM").Range("C6:c" & PMR + 5) If iKN = 2 Then Set CellRangePMR = Worksheets("PM").Range("d6:d" & PMR + 5) If iKN = 3 Then Set CellRangePMR = Worksheets("PM").Range("e6:e" & PMR + 5) If iKN = 4 Then Set CellRangePMR = Worksheets("PM").Range("f6:f" & PMR + 5) If iKN = 5 Then Set CellRangePMR = Worksheets("PM").Range("g6:g" & PMR + 5) If iKN = 6 Then Set CellRangePMR = Worksheets("PM").Range("h6:h" & PMR + 5) Best regards, Gijs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop Column | Excel Discussion (Misc queries) | |||
Loop through column headers to search from column name and get cell range | Excel Programming | |||
Loop through Column and add hyperlink | Excel Programming | |||
Loop Column letter A to Z ?? | Excel Programming | |||
HOW-TO? Loop through cells in a column | Excel Programming |