Macro to insert $ in my formulas 1

[jamminjaymeyer]

Does anyone have a macro that will insert a $ in each formula all the places there is a cell reference? so that I can move the folmulas without making the cell references change?

Make sense?

 

[SkipVought]

Hi,

I M confused! Please explain with an example.

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]

 

[bkpchs237]

jamminjaymeyer,
Unless you have a significant of already existing formulas to perform this a macro shouldn't be necessary. Even then it would problematic as the cell references vary greatly with one letter or two initially and up to five numbers representing the row.
If you want to creat an initial formula then copy it down so that items don't change you would enter the formula initially, then highlight the cell reference in the formula bar and hit your F4 key to cycle thru the absolute/relative references.
For example: if the formula in cell E1 is: =C3*1
then if you highlight C3 in the formula bar and hit your F4 key it will change to: $C$3 thus making it absolute; hit it again it will change to: C$3, then again $C3, then back to C3 again. Thus when you copy the formula thereafter it will address the change or lack thereof of a change that you desire.
Hope this helps.

 

[DPlank]

Have a star for that one!

Dave

"Probably the only Test Analyst on Tek-Tips"

Take a look at Forum1393 & sign up if you'd like