Excel 2010 Macro Copying and Pasting Data keeps failing at different points

Hi,

I have a macro that opens a CSV file and copied data. Then Opens an Excel Spreadsheet file and pastes the data into this. It works and then al of a sudden the macro fails at this point.

(grab what ever is in C2 and add it to the worksheet tab name)

SHEETS("ADDDATAHERE").NAME = RANGE("C2").VALUE

This is because the data hasnt copied across. I check and every single CSV contains data so it shouldnt happen. The issue happens at different points ofthe process and If I were to F8 through every line of code in the Macro it works fine.

It looks like a bug but I have no idea how to sort it out. I have already Set Clip Organizer to Not Available in Add remove programmes as per the advice.

I could always try a If C2 is populated then do it, else dont but Im not quite sure how to go about re coding that.

Any help would be appreciated.

Thanks

Debbie

Excellent. I will try those and let you know.

Debbie

It seems to be working.

Thanks again

Debbie