ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Relative reference (https://www.excelbanter.com/excel-worksheet-functions/8358-relative-reference.html)

Lakebum

Relative reference
 
Can you use the $ to make the worksheet relative when performing a group
change in a workbook

Arvi Laanemets

No!

Arvi Laanemets


"Lakebum" wrote in message
...
Can you use the $ to make the worksheet relative when performing a group
change in a workbook




Gord Dibben

Bum

Using the $ sign with cell references in a formula(s) makes that reference
"absolute" not "relative".

Please post back with a better description of your needs.

Is it cells refs you want relative, or worksheet refs?

Gord Dibben Excel MVP

On Tue, 28 Dec 2004 06:37:02 -0800, "Lakebum"
wrote:

Can you use the $ to make the worksheet relative when performing a group
change in a workbook




All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com