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