Need a hand with a macro
Posted by Deborah Morera on August 16, 2001 5:28 AM
Hi! I am pretty new to the world of Macros (approx. 2 hours) and the question I have is probably basic, but it's making me nuts. I will show you what I want to change in the formula first and then give you a detailed description. When I go to edit the macro the line reads:
ActiveCell.FormulaR1C1="='Client Name'!RC[1]"
I want the RC[1] to be a fixed cell (C5) instead of being relative. Basically what I want to do is for the cell that is going to contain the data to be a relative reference, but the source of the data to be a fixed reference...I have no idea how to do that. I tried replacing RC[1] with C5 and $C$5 but weird things happen. Any help would be appreciated.
Deborah
Posted by Bob T on August 16, 2001 5:38 AM
Posted by Gerry T on August 16, 2001 5:51 AM
On the Stop macro toolbar there is a relative/absolute button. Just click on this as needed to get the desire you are looking for.
Hope this helps.
