Hi nl_fan,

I seem to recollect Dave Peterson suggesting using a global search and
replace, replacing = with =


---
Regards,
Norman



"nl_fan" wrote in message
...

I am trying to write a macro that will basically F2 (edit) a cell and
hit enter to go to the cell beneath. I'd like to do this for an entire
column or range of cells.
This seems to be the only way to format some of my cells to get the
vlookup working properly, and i wind up F2-ing thousands of cells
sometimes.
Any ideas? I've looked all over MS help and can't find a thing!


--
nl_fan
------------------------------------------------------------------------
nl_fan's Profile:
http://www.excelforum.com/member.php...o&userid=14841
View this thread: http://www.excelforum.com/showthread...hreadid=264694