Search results for query: *

My macro adds data every week, and refreshes the pivot tables accordingly. I want to display all columns in the pivot table EXCEPT those values which are blank or #N/A. The added columns may have different names, so I can't request they be made visible by name (unless wildcards will work --...

I'm sure there's something simple I'm missing . . . I got the formula for adding a named range using the macro editor, and edited it to account for the last row which will vary on different reports. This syntax isn't correct though for the cell address which refers to the Detail sheet. I've...

Sendmail has been working great for most of our needs, but it would be wonderful in some cases if we could just embed the excel spreadsheet in an email (keeping the format, not just the text) rather than using sendmail where the spreadsheet is included only as an attachment. File, send to, mail...

I have this wonderful spreadsheet that the company has been using with very few issues . . . until they started upgrading some of the users to 2007. Now when a 2007 user saves a file using the macro in the 2003 spreadsheet (which ultimately creates a copy of the worksheet to a new book, removes...

I used data validation to create a drop-down list in cell b5 and named b5 "SelectRSM". Once the user selects a value from that list, I want to run macro "revise format". The macro itself runs fine when I request it, but I don't know how to get it to run automatically once the user selects a...

I created a spreadsheet that numerous people throughout the company use that uses vba to save the file to a folder on a server where the folder's permissions are set so that they can save, but cannot delete or move any files saved at that location. When the file is saved, excel ALSO saves a...

I'm almost embarrassed to ask, but obviously not too proud . . . What's the correct syntax for identifying the range of rows when I want to use a variable to identify the starting row? Rows("StartRow:1000").Select Thanks very much :) Lisa

Again, another probably simple solution that the syntax eludes me. (and I honestly don't know enough about VBA help to understand its options). I'm using ActiveWorkbook.SaveAs FileName:=LocalFileName There are a few ocassions when I know that the filename already exists, but after making...

When I use ActiveWindow.Close in an Excel macro, I don't want the user to receive the prompt "do you want to save changes? yes, no, cancel" -- What is the correct syntax to automatically select "no" without the user ever seeing the prompt. I apologize in advance as I'm sure this is something so...