| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
strange prob: file not getting closed after vlookup
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup prob with all #n/a's | Excel Discussion (Misc queries) | |||
| VLOOKUP from closed file using INDIRECT function | Excel Worksheet Functions | |||
| Strange Prob with Worksheet name | Excel Discussion (Misc queries) | |||
| Excel is not asking to save a changed file when the file is closed | Excel Discussion (Misc queries) | |||
| VBA - on a button event, open another closed file, post changes, close file | Excel Programming | |||
Threaded Mode
