Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm searching the simplest way how to address uncontinuos (sub)range of
columns. Imagine that you want to do something with columns 4 (= "D"), 7 (= "G"), 8 (= "H") and 12 (="L"). I'm trying to find something like: For Each MyCell In MyRange.Columns(4, 7, 8, 12).Cells ..... do something Next MyCell So my question is, how to address Columns(4, 7, 8, 12) by the simplest way. I welcome every good idea. Vlado |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Address blocks to columns | Excel Discussion (Misc queries) | |||
Two columns only take one name for both email address | Excel Worksheet Functions | |||
Separate address column to Five columns | Excel Worksheet Functions | |||
excel columns collection? | Excel Programming | |||
Address labels to columns | Excel Discussion (Misc queries) |