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

--
nl_fa
-----------------------------------------------------------------------
nl_fan's Profile: http://www.excelforum.com/member.php...fo&userid=1484
View this thread: http://www.excelforum.com/showthread.php?threadid=26469

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

do the cells contain the vlookup formula and it displays the formula rather
than executing the formula?

or do you mean Vlookup can't fine the value even though it is clearly there.

In the later case, format the column/cells as general. then put 1 in a
blank cell and copy it. Select the column/cells and do Edit=Pastespecial
and select just Values and Multiply.

this will convert them back to numbers.

--
Regards,
Tom Ogilvy

"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