Offsetting from the Reference of a Cell, not the cell

  • Thread starter Thread starter cdegar01
  • Start date Start date
C

cdegar01

Hi, can anyone help me with this?

In one workbook, I click on a cell and type "=" . I then switch t
another workbook, click on a cell, and press

enter. What I want to happen is have a bunch of the cells in the firs
workbook automatically reference cells in

the second workbook that are next to the one I clicked on.

The cell that I click on in the second workbook is variable/not set.
Also, I don't want to have to manually drag anything; I would like i
to be automatic.

Thanks for your help
 
Try Resize. As an example

Range("A1").Resize(3,4).Select

will select cells A1:D4.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top