mhenk
Well-known Member
- Joined
- Jun 13, 2005
- Messages
- 591
Hi all-
I am updating a file from a few years ago, and for whatever reason, it is designed using only E$4 style references.
I would like to have a macro that changed all occurances of E$4, $E4, $E$4 to E4, for example. There's a ton of them on the page, so I don't really want to manually do the updating.
Clues? Assistance? Working Macro?
any or all of those would be appreciated.
I am updating a file from a few years ago, and for whatever reason, it is designed using only E$4 style references.
I would like to have a macro that changed all occurances of E$4, $E4, $E$4 to E4, for example. There's a ton of them on the page, so I don't really want to manually do the updating.
Clues? Assistance? Working Macro?
any or all of those would be appreciated.