nc7r Posted April 10, 2008 Report Share Posted April 10, 2008 Quick question.I've gone to an Excel document which I thought / knew was absolutely fine a few hours ago, and it's showing all the formula really gay.Stuff that should just be =SUM(A1:A12) is coming out as like =R[-5]C[1]+SUM(R[-1]C[2]:R[-1]C[9])For example:I've got it showing the formula as normal Any ideas?It's a problem with my Excel, must be a setting somewhere but I've no idea where. Any ideas? Ignore me.I found it.... it was this stupid f**king tick box..No idea what R1C1 is but I hate it. Quote Link to comment Share on other sites More sharing options...
Bondy Posted April 11, 2008 Report Share Posted April 11, 2008 Whenever ive made macro's ive ended up with code looking like R[-1]C[-5] as r=row and c=column and it relates to obviously the rows and columns that the formulae is relating to from the position of the current cell, just another way of showing the default A=column 1=row etc. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.