| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to first cell in a range
Hi Friends!
I am trying to write down my very first custom function code. The function already requires the user to insert a range. Now, I also need to use the very first cell of the range inserted so. For example, the user inserts a range like: A1:G1 or A1:A6 I want to use the range as well as the very first cell, i.e. A1 in this case. How can I refer to the very first one? I have also tried the COLUMN(A1:G1) but its giving me an error in computation. All help and expertise shall be highly obliged. Best Regards, FARAZ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula referring to a dynamic range in a different workbook | Excel Worksheet Functions | |||
| Sum values referring to a cell with same value | Excel Discussion (Misc queries) | |||
| Sumif referring to range names formulas not updating | Excel Worksheet Functions | |||
| How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions | |||
| How to return a value Referring to the other cell. | Excel Worksheet Functions | |||
Threaded Mode
