Help converting Excel formula to VBA

**ks1102** · 08-21-2017, 08:51 PM

Morning All Experts

Looking for help as I'm want converting the excel formula below to VBA. The function below needs for loop down all columns "K

Please Login or Register  to view this content.

**GC Excel** · 08-21-2017, 09:24 PM

Hi,

Assuming you want the result in column C, try this code:

Please Login or Register  to view this content.

**ks1102** · 08-21-2017, 10:09 PM

Originally Posted by GC Excel

Hi,

Assuming you want the result in column C, try this code:

Please Login or Register  to view this content.

Thanks very much ! it work

Re: Help converting Excel formula to VBA