strange prob: file not getting closed after vlookup

[Guest]

I do a vlookup from a file 'A' to a file 'B' which had
some 6000 lines. I just do a vlookup on one cell and then
copy paste the remmaining cell values for speeding up.

the problem is when i am using the file for the vlookup
and in the end i close it then the file is not getting
closed. its very strange though. if i comment the vlookup
thing then at the end of the macro i can close it very
smoothly.

what is the reason. I am struggling for it for so long!

thanks in advance

 

[JulieD]

Hi

it might have to do with calculating the workbook .. you might like to turn
automatic calculation off in your code at the start of the procedure

Application.Calculation = xlManual

and then turn it back on at the end and see if this makes a difference

Application.Calculation = xlAutomatic

Cheers
JulieD

 

[Guest]

Hey
thanks julie
the problem still persisits. its only when i complete the
macro and in the end if i try and close the workbook "B"
its takes time. (the macro is written for workbook "a".
this is a very strange thing.

i am not writing anythin gin workbooks"B" ... if ideally i
open it and then close it ; it closes imm and smoothly,

whereas if i do a vlookup using that workbook then it
simply hangs!!!!!!

what could be the problem...i am scratching my head since
morning!

 

[JulieD]

I may be on the wrong track here, but i've had problems in workbooks where i
have a lot of VLOOKUP statements as VLOOKUP is volatile and keeps wanting to
recalculate all the time ..

so maybe after running the code, you turn calculation to manual (tools /
options / calculation - manual) and then try & close the workbook.

Cheers
JulieD




line in the code but remove the o

 

[Guest]

ni it jsut doesnt work..

i have given up..,.:-(((((