VBA equivalent to excel formula MATCH(TRUE,INDEX(ISNUMBER(8:8,0),0)

Hi,

New to VBA. Trying to identify the first numeric column in row 8:8 and store it in a variable for later use. I know I can achieve that with an excel formula MATCH(TRUE,INDEX(ISNUMBER(8:8,0),0).

My attempt at a solution:

Please Login or Register  to view this content.

Gives the error:
Run-time error '1004':
Unable to get the Index property of the WorksheetFunction class

I'm sure this is something straightforward but I wasn't able to figure it out by looking at the other posts here.

Help much appreciated .

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Or maybe just

Please Login or Register  to view this content.