Formula Question
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 |
Formula Question
=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 |
Formula Question
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 |
All times are GMT +1. The time now is 08:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com