I have a new program using the XLGetSelectedCell command and it works on my computer (Windows 10, Excel 2016) when run from MS, but when I compile the program and run it doesn't return values and doesn't throw an error. I am running MS V15.0.08.
Upon further investigation, I noticed a discrepancy between the command reference and the code builder. In the command reference it says "XLGetSeletedCell>XLBookHandle,SheetName,row,column" and in the code builder the format is "XLGetSeletedCell>XLBookHandle,value,row,column".
Wondering if this is a known bug, or if it is unique to me.
XLGetSelectedCell
Moderators: Dorian (MJT support), JRL
Re: XLGetSelectedCell
**Update**
Upgrading to V15.0.09 seems to have fixed the compiled program.
Still a discrepancy between the Code Builder and Command Reference. Looks like the Code Builder format is the correct one.
Upgrading to V15.0.09 seems to have fixed the compiled program.
Still a discrepancy between the Code Builder and Command Reference. Looks like the Code Builder format is the correct one.
- Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: XLGetSelectedCell
Hi,
Yes, you are right - the correct definition is:
XLGetSeletedCell>XLBookHandle,value,row,column
I have update the manual accordingly:
https://www.mjtnet.com/manuals/v15/HTML ... dcell.html
Yes, you are right - the correct definition is:
XLGetSeletedCell>XLBookHandle,value,row,column
I have update the manual accordingly:
https://www.mjtnet.com/manuals/v15/HTML ... dcell.html
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?