Hi,
I have a formula in Cell A1
=BOQ!N528
In cell B1 i need the value 528
I would like a formula to extract the row number from the formula in cell A1
Hope someone can help
Regards Peter
Hi,
I have a formula in Cell A1
=BOQ!N528
In cell B1 i need the value 528
I would like a formula to extract the row number from the formula in cell A1
Hope someone can help
Regards Peter
I was over thinking it.
Settled for
=VALUE(MID(showf(A1),7,4))
since i know the mid point
Regards Peter
Welcome to Ozgrid. Please read the Forum Rules, I have added code tags for you this time.
You don't need VBA to show the formula you can use the
=FORMULATEXT(A1)
Thanks Roy, works well.
Pleased to help