VBA Vlookup Problem

Hi

Can't see why, but the only thing I can think of is that it is getting hooked up on the R1C1 format

Try

Range("F2").Formula = "=IF(ISNA(VLOOKUP(G2,Lookup!A:A,1,FALSE)),""Not Found"",""Found"")"
  Range("F2").AutoFill Destination:=Range("F2:F65000")

Also, do you really want it to go down that far? Will take up a lot of memory.....


rylo

i just tried that and it did not work either

You're right about the memory...this is just a test to make sure I can get this macro to work as planned.

Unfortunately this stumbling block has hindered my progress

Hi

What reference style do you have in your sheet? R1C1, or non R1C1?


rylo

I used the R1C1

Hi

Try changing it to the non R1C1 and run the code. If it calculates properly that way, then add the conversion to the start of the code, then turn it back again at the end. Record a macro to get the code to do those steps.

If that doesn't work, then let us know...

rylo

I've tried using both R1C1 and non and both didn't work. Recording the macro hasn't worked either because it gives me that same code. Is there code for the cursor placed in the formula bar then to press enter. That is what I have to do in order for it to calculate correctly.

Hi

If the workbook isn't too large, then try dragging each of the sheets to a new workbook, save it and see if that will work with the R1C1 set to the A1 format.

If that doesn't work, then the only thing I can think of is to go down the column and make each of the formulas equal to the formula. This should have to same effect as editing, but (a) you shouldn't need to do it and (b) it will take some time.

Any chance of putting up the workbook, or an example file that is doing the same thing???

rylo