Forum Discussion
mikhanx1
Jan 21, 2022Copper Contributor
Description of Excel VBA function
Hi, Can anyone please tell me how can we assign description to excel VBA function? For example when we type Average it shows it's description as shown in figure below. I want to do the same with my ...
NikolinoDE
Jan 21, 2022Gold Contributor
here is a link with an average example
Dim myRange as Range
'Loop code here
Set myRange = Range("L" & i & ":L" & k)
Cells(j, 20).Value = Application.WorksheetFunction.Average(myRange)
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
mikhanx1
Jan 28, 2022Copper Contributor
Thank you so much.