LinkBack URL
About LinkBacks
whitoulias 
Hallo to all
In column B -starting from B2- i have a set of numbers which varies from time to time
I would like to average those numbers in the next not used cell
Any help would be appreciated
Hallo to all
In column B -starting from B2- i have a set of numbers which varies from time to time
I would like to average those numbers in the next not used cell
Any help would be appreciated
Try running this:
Sub Avg() With Range("B" & rows.Count).End(xlUp) .Offset(1).Formula = "=AVERAGE(" & Range("B2:B" & .row).Address & ")" End With End Sub
多么想要告诉你 我好喜欢你
millz
thx a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks