Error copy paste vba work-around

New Contributor

I've Copied and Pasted VBA code and it doesn,t work>

excel 2013

Finally, All I did to Fix was to retype it and it worked! 

2 Replies
Depending on where you copied the VBA code from, pasting may have added special characters which the VBA editor does not like. It sometimes helps to first paste in NotePad and then copy from notepad into the VBA editor.

@Don Bleeker 

Thank You