sspatriots
Well-known Member
- Joined
- Nov 22, 2011
- Messages
- 585
- Office Version
- 365
- Platform
- Windows
I'm hoping this is an easy fix, but can't seem to get there.
I have the following line of code:
How can I get this all on one line without causing an error message. The reason it sows "Cab PO" jumping to the next line is because the header name has a hard return that puts it on the next line. I tried to use:
However, that did not work. Thanks in advance for any assistance on this.
I have the following line of code:
VBA Code:
=IF(ISBLANK(XLOOKUP([@[Cab
PO]],'PO Block History - DEM.xlsm'!Table7[COMPL PO NO CORR],'PO Block History - DEM.xlsm'!Table7[Date Received:])),"",
How can I get this all on one line without causing an error message. The reason it sows "Cab PO" jumping to the next line is because the header name has a hard return that puts it on the next line. I tried to use:
VBA Code:
"Cab" & CHAR(10) & "PO"
However, that did not work. Thanks in advance for any assistance on this.