Look at this link to understand R1C1 and A1 convention differences

http://office.microsoft.com/en-us/ex...005198323.aspx