In VBA code, if you have a quote within a quoted string, you must repeat the quote twice.
etc.![]()
.Range("N24:N" & LastRow5).Value = "=IF(E.Data!S2="""","""",E.Data!S2&CHAR(10)) & IF(E.Data!Y2="""","""".........
In VBA code, if you have a quote within a quoted string, you must repeat the quote twice.
etc.![]()
.Range("N24:N" & LastRow5).Value = "=IF(E.Data!S2="""","""",E.Data!S2&CHAR(10)) & IF(E.Data!Y2="""","""".........
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks