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