emorris1000
Registered User.
- Local time
- Today, 15:44
- Joined
- Feb 22, 2011
- Messages
- 125
Having an issue with an R1C1 call, thought you guys may have some idea what I'm doing wrong here.
Apparently just putting the R1C1 into excel it doesn't like it either. Its supposed to be a ratio between the relative row, 14 columns over, and a static position at Row 2, column 15.
When I just plug it into Excel it doesn't seem to like the "R2C15" thing, and will switch it to RC215. I could have sworn you could put an absolute reference in like that.
Any idea what I derped up here?
Edit: Ok....this is a new record for me. When I was pasting it into Excel I had switched back to A1. Right before I switched back to A1 I corrected a typo.
....everything is fine. Move along....nothing to see here....
Code:
.Range(.Cells(2, 2), .Cells(Seriescount + 1, 2)).FormulaR1C1 = "='ProcessData'!RC[14] / 'ProcessData'!R2C15"Apparently just putting the R1C1 into excel it doesn't like it either. Its supposed to be a ratio between the relative row, 14 columns over, and a static position at Row 2, column 15.
When I just plug it into Excel it doesn't seem to like the "R2C15" thing, and will switch it to RC215. I could have sworn you could put an absolute reference in like that.
Any idea what I derped up here?
Edit: Ok....this is a new record for me. When I was pasting it into Excel I had switched back to A1. Right before I switched back to A1 I corrected a typo.
....everything is fine. Move along....nothing to see here....
