Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

Anchors Away

Posted by Joe c on December 18, 2001 9:18 AM

Is there a way to put anchors($) on all of the cell references in multiple cells. I cant figure it out??
I figure how to do it for one cell.

Re: Anchors Away

Posted by Russell Hauf on December 18, 2001 10:25 AM

Try the link below (hope it helps):

MSDN link

Re: Anchors Away

Posted by Joe c on December 20, 2001 7:53 AM

Worked perfectly.
Many Thanks

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.