Macro LoC

[klogue]

Hi

Is there any approach to determine the number of lines of code within a macro. I’m looking something equivalent to the VB code below

With ActiveWorkbook.VBProject

For i = .VBComponents.count To 1 Step -1

Dim loc As Integer

loc = .VBComponents(i).CodeModule.CountOfLines

If loc > 0 Then

MsgBox (loc)

End If

Next i

End With

Thanks

Kevin

[Amjad_Sahi]

Hi,

I am afraid, we don’t support to access or manipulate macros, so your desired feature is not available at the moment. I have logged your feature request into our issue tracking system with an id: CELLSNET-20488. We might look into it in future.

Thank you.