VBA - Copy paste values from a blank formula returning "0"

**LeeBillington** · 06-02-2018, 07:37 AM

Hi guys, so i am using this to copy to another sheet & paste values, but if the formula its copying is blank why is it showing 0 once copy & pasted values.. when it should be empty/blank?

the formula its copying is:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks.

**davesexcel** · 06-02-2018, 02:36 PM

you have a space between those quotes

VBA - Copy paste values from a blank formula returning "0"

LinkBack

Thread Tools

Rate This Thread

Display

VBA - Copy paste values from a blank formula returning "0"

Re: VBA - Copy paste values from a blank formula returning "0"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy Paste Values Except Formula which having "Sum" function.

[SOLVED] One column has "Y"s and "N"s, both in black type. Want to change "N"s to red.

[SOLVED] "MAX" Formula returning a result of "0" for cells containing "IF" Formula results

Finding the largest absolute values but returning the "+" "-" sign

Filter by "Confirmed" and by "Date (confirm or order)" copy and paste to "Invoice Audit"

[SOLVED] Need to modify the Paste function of this VBA Macro from "Paste" to "Paste Special Values"

Formula returning result of "True" or "False" instead of "1" or "0"

Bookmarks

Bookmarks

Posting Permissions