02-25-2007, 07:21 PM
Sorry,
I think it had to do with the large amount that had to be compared or something, but there is nothing compared, if the string and the excel are the same the outputbox gives only "sheet exists=1, dataexists=0 " and nothing is added to the sheet. I changed the range to compare to a1:a200 for faster handling. also when i add a new number to the string it doesn't recognize it and doesn't add it to the sheet.
Freggel.
I think it had to do with the large amount that had to be compared or something, but there is nothing compared, if the string and the excel are the same the outputbox gives only "sheet exists=1, dataexists=0 " and nothing is added to the sheet. I changed the range to compare to a1:a200 for faster handling. also when i add a new number to the string it doesn't recognize it and doesn't add it to the sheet.
Freggel.