Please help with xldown
Posted by Pavan on August 02, 2001 3:36 PM
Hi, I have a list of 2000 numbers in column A and 2000 coressponding titles in column B. Once in a while someone may type leave an empty row all together. I want to catch this error, return an error message, and end sub.
If there is an empty row in row 1 or 2, the code:
returns 2 or 3 respectively. How can I get excel to return error or 0 if there is no data in A1 (but data in 2 and beyond), or 1 if there is data in A1 and A3 and not A2?
This is really stumping me. If anyone can help me out, it would be appreciated. Thanks,