| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet function to retrieve cell value based on row an col numb
I want to be able to reference cells by the row number an column number
rather than using the column letter. I am contatenating strings to make a formula where I increment the column. I have tried r1c1 notation and this doesn't seem to work for me. Is there a function like +cellvalue(1,1) that will return the value in a1? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
| Can I modify cell attributes (font,color etc.) based on function . | Excel Discussion (Misc queries) | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
Threaded Mode
