Search results for query: *

When I refresh the PT, the original weeks which were selected are still selected, the two values which were not selected ( "(blank)" and "#N/A") are still not selected, and the new value, is not selected. In order for the pivot table to add the additional column, I need to physically select the...

The data range is currently set for A:X -- (I know that's not good, but it's not my creation). I've used your suggestion before in 2003 (naming the data range), but I'm guessing because 2007 allows the user to specify each label, it doesn't pick up the new date since the default filter doesn't...

Because it keeps the other fields as originally selected, and all I'm doing is adding the newest week, this is all that is recorded: With ActiveSheet.PivotTables("PivotTable9").PivotFields("Query Establish Week") .PivotItems("Week Starting April 26").Visible = True End With...

I agree that this pivot table is probably not the best way to go with what is being accomplished, but it was set up by an outside agency, and we're stuck with it. The original data which the pivot table draws from is on Tab 1, and it contains a column which identifies the week that particular...

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 --...

Thanks so much, that's exactly what I needed . . . appreciate all the input and comments! :)

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...

Excellent -- already updated my macros -- can't wait to try it out on Monday! Thanks very, very much! And Roy, very informative! Tx!

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...

That was perfect -- Thanks again very much!

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

Absolutely works perfectly!!! Thanks so much! :)

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...

activewindow.close (false) was exactly what I was looking for -- works perfectly! Thanks so very much, :)

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...