I received this email from some so-called moderator.. the email was a total non-sense.. i didn't spam the group, I just replied to a member's query.
Anyone who uses excel could understand the email and the attachment... Here is the content of the excel sheet I attached. The excel sheet contained an example for this. Function NAverage(NRange As Range, NName As String, VColNum As Integer) Dim cRange As Range Dim v As Integer Dim vAvg As Integer vAvg = 0 v = 0 For Each cRange In NRange If cRange.Value = LCase(NName) Then vAvg = cRange.Offset(0, VColNum - 1) + vAvg v = v + 1 End If Next cRange NAverage = vAvg / v End Function _________________________________________________________________________________________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." ________________________________ From: "excel-macros+ow...@googlegroups.com" <excel-macros+ow...@googlegroups.com> To: alokeshwar.tiw...@yahoo.com Sent: Monday, 2 March, 2009 12:48:52 PM Subject: Re: (Posting denied) $$Excel-Macros$$ How to summarize worksheet Data Your message to the MS EXCEL AND VBA MACROS group has not been approved as being reported spam by prominent users of the group. Reason by Manager:- Dear User, Please do not attach files and send to this group without any description. Please provide appropriate and true description of the attached files, not following of which will force us to take a hard decision in future. We really appreciate your posts/replies but are bound to our policies. Hope you understand us and will support us in benefits of all users like you. Thanks and Regards Ashish Jain Get perfect Email ID for your Resume. Grab now http://in.promos.yahoo.com/address --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---