Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Coding macros

Comment:

Is there a way to code in excel where I can say... Take the average of all the columns where the first cell is coded "1"

Name: chnos
Date: February 27, 2004 at 00:21:27 Pacific

Reply:

yes, with a pivot table.

0

New identity + existing d...

MS Word 2002 highlights e...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I recorded a macro: Crtl-A Crtl-C Edit > Paste Special ... unformatted Text The code generated was: Selection.WholeStory Selection.Copy Selection.PasteAndFormat (wdPasteDefault) When I ran...

Summary: I created an Excel template with macro code in VBA. Everytime I open the template and save as another file I have to edit a typo that I made in the VBA code even though I corrected the typo in the tem...

Summary: Hi i have record one macro which ask user to open file and after user open the file another macro copy some column as per requirements i m getting error if user select different file name other than t...