Hi there,

Is it possible to dynamically set a range of cells in code.

eg

instead of

Range("A2:E11").Select
Selection.Copy

Can I set the 2 and the 11 dynamically, something like

dim i, j
i = 2
j = 11

Range("Ai:Ej").Select
Selection.Copy

which obviously doesnt work

Thanks
Stevie


--
StevieH
------------------------------------------------------------------------
StevieH's Profile: http://www.highdots.com/forums/m962
View this thread: http://www.highdots.com/forums/t3013129