Requesting debugging help

**Butcher1** · 01-01-2015, 12:00 PM

I have this macro,

Please Login or Register  to view this content.

and am getting an error at this line, it says,
Run-time error'4198':
Method 'PasteAndFormat' of object 'Range' failed

Please Login or Register  to view this content.

This line is the 37th line down in the code.
What is the fix for this?

**6StringJazzer** · 01-01-2015, 01:30 PM

This can't be reproduced without your files. At the point where it fails, what is Rng? What is rngWord? Did the copy happen properly? I suspect that the problem may be in the Copy statement rather than the statement that is raising the error. I think that at the point where your code stops, the clipboard should have your copied content on it and you can try a manual paste into a Word document and see if that works. If it fails it may give you insight as to what's wrong. You could also try inserting a line of code that pastes into Excel instead of Word and see what happens there.

**Butcher1** · 01-01-2015, 02:51 PM

I went through your questions and was able to find the error. Thank you.

**6StringJazzer** · 01-01-2015, 03:42 PM

Glad to hear it. Care to share what you found?

**Butcher1** · 01-01-2015, 04:22 PM

As far as I can tell, the sheet had been modified but the code hadn't been updated to reflect the modification. It was trying to copy and paste a blank cell, when I changed the cell to be copy and pasted it worked.