Posts by PeterMac2020

Hi

I'm adapting some existing code that adds a photo based on the selection in a data validation list.

I'm now trying to loop through a number of rows and inserting a picture if one is found but the data validation list gets in the way when the vba moves to the next cell.

Is there another way to do this that wont trigger the data validation?

Regards Peter

Thanks Roy, works well.

I was over thinking it.

Settled for

=VALUE(MID(showf(A1),7,4))

since i know the mid point

Regards Peter

I came across a somple function to show the formula as string

=ShowF(A1) returns "=BOQ!N528" so i just need to split the string between N and 5 and convert back to a number please

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