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

--
Message posted from http://www.ExcelForum.com

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)

"cdegar01 " wrote in message
...
Hi, can anyone help me with this?

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

enter. What I want to happen is have a bunch of the cells in the first
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 it
to be automatic.

Thanks for your help!


---
Message posted from http://www.ExcelForum.com/