I want to write in my code a formula that will look at a cell in the previous
worksheet. For example, I have 26 worksheets in my workbook, I want cell D9
on sheet2 to look at cell C8 on sheet1. How would I write that formula?

Bumper

=sheet1!C8

in the worksheet

Sheets("sheet2").Range("D9").Formula="=sheet1!C8"

in VBA
--
Gary''s Student - gsnu200719


"bumper338" wrote:

I want to write in my code a formula that will look at a cell in the previous
worksheet. For example, I have 26 worksheets in my workbook, I want cell D9
on sheet2 to look at cell C8 on sheet1. How would I write that formula?

Bumper

hi,
no. worksheet control "float" on top of the sheet. they cannot be assigned
to rows, columns or cells. they do tend to "stay put" but actions like delete
or add rows/columns tend to make them shift some.

sorry
regards
FSt1

"bumper338" wrote:

I want to write in my code a formula that will look at a cell in the previous
worksheet. For example, I have 26 worksheets in my workbook, I want cell D9
on sheet2 to look at cell C8 on sheet1. How would I write that formula?

Bumper