Good morning,
I would like to calculate an average value in VBA by having the number of the last row as a variable. My version does not work... Can you help, please?
Thanks a lot in advance
Please Login or Register to view this content.
Greetings
Moni
Try this...
The average function will ignore text and blanks. You may also just use...Please Login or Register to view this content.
=Average(L:L)
Last edited by AlphaFrog; 01-31-2018 at 03:24 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Ah, perfect, thanks :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks