quotes within quotes in VBA

[howardgrigg]

why does this macro fail when f I copy and paste the exact same formula into the cell the formula works perfectly? (this is just one line of a larger macro but this is where it is getting stuck)

Please Login or Register  to view this content.

Thanks

[jasoncw]

Whenever you have quotes within quotes in VBA, you need to double them up. So on both sets of "", change them to """".

HTH

Jason