Formula Question

[Guest]

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

 

[Guest]

=sheet1!C8

in the worksheet

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

in VBA

 

[Guest]

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