Count Values in a Column by referring to the Column NUMBER

[music_al]

Hi

I'm using the MATCH function to return the column number where specific text was found in a row.

That number (say 7) is stored in a variable (MyCol).

I now want to COUNT the number of values (text and numbers) in column MyCol.

How do I do this ?

Thank you in advance

Al

 

[Fluff]

Re: Cout Values in a Column by referring to the Column NUMBER

Like

Application.CountA(Columns(mycol))

 

[music_al]

Re: Cout Values in a Column by referring to the Column NUMBER

That works fine - thank you.

 

[Fluff]

Re: Cout Values in a Column by referring to the Column NUMBER

You're welcome