Select Multiple Cell Macro

[xiao85yu]

Hello!

Range(Cells(TMapRowCount, 1), Cells(TMapRowCount, TMapColCount)).Select
Selection.Copy

So say right now my rowcount is 11 and colcount is 3, I want to ONLY copy the contents in Cell(10,1) and Cell(10,3).

The above will highlight the contents of Cell(10,2) as well, when I tried to record a macro it just gave me Range("A11,C11").Select --- but i'm having trouble doing this with Cells(x,y).

Any help would be appreciated thanks!

[StephenR]

This appears to work (Select not needed btw):

Please Login or Register  to view this content.