Macro to put $ into formula. sheet!A1 to sheet!$A$1

[krabistaja]

Hello.

I need to select big area with formulas - copy and paste below this selected area - and I dont want to formulas to change.

I could put $ into formulas 1 by 1 but I want to do it once with macro.

Please help.

Futher development of this macro would be: I select area and press macro - message box askes me - "do you want to lock rows, columns, or both?" - and then I choose 1.

 

[PaddyD]

check out the recommended links thread & follow the links for the asap utilities addin, which already has similar functionality.

 

[Richie(UK)]

Hi,

In addition to Paddy's suggestion, see also my post here:

http://www.mrexcel.com/board2/viewtopic.php?t=109735&highlight=formularefchanger