the formula array treats RC8 and RC9 as the actual cell.Please Login or Register to view this content.
Could you please give an insight as to why it is doing this.
the formula array treats RC8 and RC9 as the actual cell.Please Login or Register to view this content.
Could you please give an insight as to why it is doing this.
Because there is no way of knowing whether that formula is R1C1 or A1 style. If you want to force R1C1, use:
Please Login or Register to view this content.
Another possibility to get the syntax correct, maybe:
Record a macro whilst typing the Formula manually into the sheet, ( Make sure you type it in in the correct CSE way )
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks