Pasting a range changes some formats to date

Hi, I have a macro that pastes a range into a sheet and then loops column A of the pasted range to strip out the leading characters

Here is the list of the values in column A and then after the = it shows what ends up on my target sheet
WSRE326057 = 16/09/2792
WSRE326294 = 11/05/2793
WSRE326326 = 12/06/2793
WSRE326371 = 326371

I can format the cells after the even to be "General" but it's really bugging me that my macro wont just paste what I have copied.

here is the little bit of loop code that strips out the leading values

Please Login or Register  to view this content.

Hope someone can help

Thanks
John

Hi, thanks for the reply and sorry for my late response.

I've found the cause of the problem now. Column A of my original range that I was copying had some cells formatted as date (but I didnt realise as the values looked like text). I have now changed the original copy range to be text format and all works fine now.

Only thing I was still confused about was the fact that cell.numberformat = "General" would always result in an error. Excel seemed unable to convery from date to General. Anyway I've fixed the cause of the problem so I'm not too concerned about that now.

Thanks again for your reply

John