Converting column & row numbers to a cell reference
Hi!
Try these:
=ADDRESS(10,2,4) = B10
=ADDRESS(5,10,4) = J5
Biff
"Graham Tritton" wrote in message
...
I need to convert the column and row numbers into a cell reference. EG.
2,10 converts to B10
10,5 converts to J5
Anyone have any ideas?
|