I am back with another issue for me. I already know how to work with named ranges and create OPER with reference to sheet I need.
But now I tried to read namedrange where row is higher then 0xFFFF and I have problem, I thought that I can use always OPERX to cover any version of excel.
so to simlyfy I tried this code
ExcelX(xlcAlert, ExcelX(xlCoerce, o));
and I have this error:
Error 1 error C2220: warning treated as error - no 'object' file generated macro.cpp 34 1 XllProjectTEST
Warning 2 warning C4305: 'argument' : truncation from 'int' to 'unsigned short' macro.cpp 34 1 XllProjectTEST
Warning 3 warning C4309: 'argument' : truncation of constant value macro.cpp 34 1 XllProjectTEST
I have VS2010Pro and Excel2007.
many thanks for your time,