program a cell in excell to reference a cell below a referenced ce

[Guest]

in my program Cell 1 references a specific cell in another worksheet. In my
program Cell 2 wants to reference the cell below the referenced cell in Cell
1. i am using Cell 1 as my reference point so Cells 2, 3, 4, 5, 6, etc...
will reference the data/Rows below the Referenced cell in the other
worksheet.

 

[Norman Jones]

Hi Josh,

Try something like:

Dim rng1 As Range, rng2 As Range, rng3 As Range

Set rng1 = Sheets("Sheet2").Range("A1")
Set rng2 = rng1(2)
Set rng3 = rng1(3)

 

[Tim Williams]

set Cell2 = Cell1.offset(1,0)
set Cell3 = Cell1.offset(2,0)
'etc etc

Tim