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="""","""".........
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks