Assign array

**welchs101** · 09-02-2011, 08:34 PM

thanks Leith Ross.......but how did the code know correct area? I still dont understand how only the area i wanted got selected/determined?

**Leith Ross** · 09-02-2011, 08:39 PM

Hello Welchs101,

I will have to look at the complete macro to give you more details.

**Leith Ross** · 09-02-2011, 08:56 PM

Hello Welchs101,

Here is the address string returned from by the method SpecialCells(xlCellTypeConstants):

$C$1,$B$1:$B$12,$A$1:$A$13,$A$15,$C$18,$B$18:$B$29,$A$18:$A$30,$A$32

Only the header rows in column "C" (C1 and C18) are shown as single cells because the other cells contain formula results and not constants. Columns "A" and "B" cells are all constant values.

Column "C" values are not included because their row count is only 1, due to it being a header. Only columns "A" and "B" cells of each row are saved to the active_array .