when I record a macro the relative reference button has gone away since I put the record button on the toolbar. How can I toggle back n forth from absolute/reference now that I can not find it? Any ideas??
If you want A1 to be an absolute reference, select it with the cursor in the formula box then hit F4 on your keyboard. It will toggle through absolute reference, relative row reference, relative column reference, and no reference.