Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lakebum
 
Posts: n/a
Default Relative reference

Can you use the $ to make the worksheet relative when performing a group
change in a workbook
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

No!

Arvi Laanemets


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



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Relative Reference Barry Givens via OfficeKB.com Excel Discussion (Misc queries) 3 December 17th 04 07:31 PM
relative reference Charlie New Users to Excel 3 December 3rd 04 07:22 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
How do I reference multiple rows Awetronics Excel Worksheet Functions 1 November 4th 04 12:37 AM


All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"