Find the column number

[trprasad78]

Hi i need VBA Coding to find Column number where current month is following.

Default Row number 17 have months, in that we need to find the current month column number.

sample file attached
Thank you

 

[vletm]

trprasad78
You could find it eg this way..

 

[trprasad78]

Thank you for fast response

 

[Hareesh_KLD]

Hi Prasad,
check the attachment

 

[GraH - Guido]

Or 2 alternative without VBA: formula, or CF...

 

[trprasad78]

Or 2 alternative without VBA: formula, or CF...

Thank you, I am looking for VBA code , i taken from Hareesh shared file.