Graham Tritton

Posts: n/a

Converting column & row numbers to a cell reference

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?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
return cell reference from any column	Pirjo	Excel Worksheet Functions	2	September 9th 05 06:11 AM
Way To Copy Formula In Column Without Changing All Cell Numbers	travelersway	Excel Discussion (Misc queries)	2	September 3rd 05 08:36 PM
Input cell reference is not valid (One Variable Data Table)	Dottore	Excel Worksheet Functions	9	September 1st 05 03:05 PM
reference cell value from fixed column with variable row	bob z	Excel Discussion (Misc queries)	0	May 23rd 05 11:30 PM
up to 7 functions?	ALex	Excel Worksheet Functions	10	April 12th 05 06:42 PM

All times are GMT +1. The time now is 10:07 AM.

About Us

"It's about Microsoft Excel"