VBA - code copying non random value instead of criteria value

**shido** · 08-29-2015, 05:13 PM

Hi All,

I have created post yesterday "http://www.excelforum.com/excel-programming-vba-macros/1101634-vba-code-not-copying-value-f8-not-showing-any-error.html#post4176144" and it works fine when i tested it.

However, when i add codes in my master code, i am experiencing issue. I have code to copy values from x # of columns based on criteria and send to the recipient via email by recipient in row $1:$1 . However, my code is not copying “Yes” criteria values. Instead, it pick non-random value from the column.

Can you please see the attachment and advise me where I am doing it wrong.

Thank you and Kind Regards,

**shido** · 08-30-2015, 12:45 PM

Hi All,

My codes is as follows,

May be it can help to answer my issue

Please Login or Register  to view this content.

Thank you

VBA - code copying non random value instead of criteria value

LinkBack

Thread Tools

Rate This Thread

Display

VBA - code copying non random value instead of criteria value

Re: VBA - code copying non random value instead of criteria value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA - code not copying value (f8 not showing any error)

[SOLVED] Runtime error 1004 range of object with VBA code for copying all worksheets to word

Showing Run-time error "1004" when executing code with thousans of data

[SOLVED] VBA Code is copying a single cell only. Please spot the error for me.

code error - copying from multiple sheets to one file

Error with VBA code Copying cells to a closed workbook, template sheet, documents and

Code not copying and pasting data - basic error?

Bookmarks

Bookmarks

Posting Permissions