RunTime error 438 on adding formulas and pasting them as values.

**PaulM100** · 06-29-2018, 06:15 AM

Hi,

I have the following piece of code:

Please Login or Register  to view this content.

On the red coloured part is returning a 438 error. I've searched and read about it, but I cannot figure it out. Any ideas why it returns an error?

Many thanks in advance,
Paul

**rorya** · 06-29-2018, 06:37 AM

I think you meant wsDest not wbDest, and you haven't properly qualified your ranges:

Please Login or Register  to view this content.

**PaulM100** · 06-29-2018, 06:55 AM

So silly from me. Haven't figured out by myself. Now it works, but it doesn't apply the formula. Basically, it doesn't returns the results. I've tried changing it to

Please Login or Register  to view this content.

setting the wsSource as

Please Login or Register  to view this content.

but it returns the same error again.

**PaulM100** · 06-29-2018, 07:29 AM

Nevermind, fixed it.

RunTime error 438 on adding formulas and pasting them as values.

LinkBack

Thread Tools

Rate This Thread

Display

RunTime error 438 on adding formulas and pasting them as values.

Re: RunTime error 438 on adding formulas and pasting them as values.

Re: RunTime error 438 on adding formulas and pasting them as values.

Re: RunTime error 438 on adding formulas and pasting them as values.

Thread Information

Users Browsing this Thread

Similar Threads

runtime error 1004 when pasting pictures

Runtime error 5345 while pasting chart from Excel into Word

VBA Runtime Error 438 When Adding Chart

Runtime Error - Type Mismatch when copying and pasting cells in sheet with macros

Runtime error 1004 when copying & pasting data to another sheet

Copy and Pasting Issue (Runtime error '1004')

Runtime error 1004 when copying and pasting a filtered collumn excel 2010

Bookmarks

Bookmarks

Posting Permissions