Non Contiguous range of cells identified only at run time

[EmmaEmu]

Ok so I would like to define all the points in the vba but they aren't next to each other.

range("A1").select
selection.end(xltoright).select
endcol = selection.column
otherrow (This is determined by earlier code)
select information in row 1 from col 1 to endcol and information in otherrow to endcol

Hope this makes sense thanks for your help

[JosephP]

what is otherrow? a row number or cell or an entire row?

[EmmaEmu]

The other row is a loop I go down a row so it will send the row number to the variable otherrow and then row 1 to endcol and otherrow 1 to endcol need to be selected.

eg first time through the selection might be range("A1:A10, C1:C10") next time range("a1:a10,e1:e10")

Thank you for your help

[Andy Pope]

Please Login or Register  to view this content.

[EmmaEmu]

Thank you - Worked