Excel Application.SetReferenceStyle

W

Where am I?

Trying to get a range using the R1C1 nomenclature, the following code fails:

objApp.SetReferenceStyle((long) (-4150)); // xlR1C1
lpDispatch = objSheet.GetRange(COleVariant("R1C1"), COleVariant("R1C1"));

How do you use R1C1 addressing in [MFC] C++?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Programming: SetItem and SetValue Does Not Work 0
GetValue() Does Not Work 0
Can't open version 2010 .docx in the program 0
Word automation 'SaveAs' 0
OLE Automation "DisplayRulers is not a method" 2
SetItem and SetValue Does Not Work 0
Word Automation 0
MS Word-search & replace certain strings in header,footer,textbox( 1

Top