Hi
try the following:
- select your data range
- hit F5, click 'Sepcial'
- choose 'Empty/blank cells'
- enter the euqation sign '=' and hit the upper arrow
- hit CTRL+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany


Jeffers185 wrote:
Is there a quick and easy way to finding a solution to this problem
or will a macro have to be written? I have no experience with writing
macros and wouldn't know where to start.