... during the the import of the txt file i recieve "error 1004"???????????????????
Macro is in module2
The file of txt is in the zip file (regione.02)
... during the the import of the txt file i recieve "error 1004"???????????????????
Macro is in module2
The file of txt is in the zip file (regione.02)
Because REGIONE_DISK!$A$2 is Empty ..
FirstFree returns nothing, so n is empty, so ..
Elenco.Range("A" + CStr(n)) resolves to Elenco.Range("A"), which is not a valid address
Enjoy,
Tony
---------------------------------------------------------------
Give a man a fish and he'll eat for a day.
Teach him how to fish and he'll sit in a boat and drink beer all day.
I'm (slowly) building my own site: www.WordArticles.com
OK! in Module2 is possible to make a control on a column A (there are UNIQUE ID) if for error the user reimport the same file?