Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - How to check if value exists in closed workbook?
[Sorry, I mistakenly posted this to the functions group. I meant to
post it here] What is the best method to validate a string's existance in a CLOSED workbook that has many filled cells? I need to check for a string in column A of an external closed book. Column A of the external book has over 47,000 filled cells. I have a VBA routine that writes a match function into a cell of thisworkbook, but I get the error alert, "Excel cannot complete this task with available resources..." when the external book is closed. However, it works fine when it's open. I've tried both the countif and match function but both fail when the external book is closed. (Excel 2003) Thank you for your help. -Chuck |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I check if a pop-up menu exists... | Excel Programming | |||
How to check from VBA if sheet exists? | Excel Programming | |||
Check if sheet exists in a closed workbook | Excel Programming | |||
check if worksheet exists | Excel Programming | |||
check if worksheet exists | Excel Programming |