reference range in other sheet

I would like to write a macro reference range. I have two sheets in the same
workbook (sheet1 and sheet2). I know when you are trying to reference a cell
in a different sheet you refer to sheet and cell (='Sheet2'!D1) but I am
trying to reference range D1:D4 on sheet 2. Is there a way to do this?

Many thanks
Diana

Dim r as range
set r=Worksheets("Sheet2").Range("D1:D4")
--
Gary's Student


"Diana" wrote:

> I would like to write a macro reference range. I have two sheets in the same
> workbook (sheet1 and sheet2). I know when you are trying to reference a cell
> in a different sheet you refer to sheet and cell (='Sheet2'!D1) but I am
> trying to reference range D1:D4 on sheet 2. Is there a way to do this?
>
> Many thanks
> Diana
>
>