I have a large (very) range of cells that are presently referencing other cell values cells relatively - I need to convert them to absolute reference (the F4 command) but there are too many to do individually...
I tried to make a macro, but cant make it work.
The cells I need to change are in columns. Any ideas?
Steve
I tried to make a macro, but cant make it work.
The cells I need to change are in columns. Any ideas?
Steve