setting a range dynamically

[StevieH]

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

[Dave Peterson]

range("a" & i & ":E" & j).copy
or
range(cells(i,"A"),cells(j,E)).copy


StevieH wrote:
>
> 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

--

Dave Peterson