Hi all,
I have an array of indirect formulae (K2:N44), which as you can image are slowing down the processing on the sheet and annoying users.
Fortunately, these formula aren't a necessity at all times.
I was hoping to therefore make a macro which would remove the "=" from the first character in the cells and then another macro to add it back in as the first character.
Not used VBA in some years was hoping there was a simple solution.
Thanks,
Marc
I have an array of indirect formulae (K2:N44), which as you can image are slowing down the processing on the sheet and annoying users.
Fortunately, these formula aren't a necessity at all times.
I was hoping to therefore make a macro which would remove the "=" from the first character in the cells and then another macro to add it back in as the first character.
Not used VBA in some years was hoping there was a simple solution.
Thanks,
Marc