VBA and F2 programming question

  • Thread starter Thread starter nl_fan
  • Start date Start date
N

nl_fan

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
 
Hi nl_fan,

I seem to recollect Dave Peterson suggesting using a global search and
replace, replacing = with =
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get rid of need for F2.Select 3
Write to intersect of a row and column 7
Press F2 with vba 4
VBA set thick borders around non empty cells in range 0
place a formula in a cell with macro 7
Copy to a mid column range Row 10 - Row 20 4
Problem sorting a range of columns using VBA 1
F2 Cells in a column 8

Back
Top