| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
reference range in other sheet
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Cell Reference with Range Name | Excel Worksheet Functions | |||
| Dynamic reference to a sheet | Excel Worksheet Functions | |||
| Copying a range to another sheet | Excel Discussion (Misc queries) | |||
Linear Mode
