General

Macro
Can someone help me with macro? I have data that need to be pulled by weekly with date range. Right now I have data pulled in pivot table that I go to each pivot table and filter the dates. Is there a way that I can use macro to pull data, using pivot table, base on date range? For example, date range from ... 22 Mar 2010 11:53

stop error message when opening a non existant file in a macro
In a macro jn Excel 2007, I am opening files from a list, when the file doesn't exist I get an error message. How can I stop this and go on to the next one? I can stop the first with an onerror statement but if it finds a second non-existant file it ignores this and gives an error message. ... 22 Mar 2010 11:53

Menus in xlmenubar
Sub Macro1() MenuBars(xlWorksheet).Menus.Add Caption:="&Name1", before:="&Help" With MenuBars(xlWorksheet).Menus("&Extras").MenuItems .Add Caption:="Name1", OnAction:="Macro2" .AddMenu Caption:="menu1" End With End Sub how do i add a new caption to menu1 and also the onaction could... 23 Mar 2010 04:33

Any way to get Freeze Panes to work with Split View?
Freeze Panes disappears if I split the view. Worse is if I try my general technique of selecting row or column prior to splitting view to split as I want it, it always does the opposite, and then when I do it again moves me to the top column losing my place (this if i try to do so with Freeze Panes on. I ofte... 22 Mar 2010 14:16

Inserting Rows...but losing "FORMAT"
I have a spreadsheet that I have used for 5 years...with daily data being inputted (in newly inserted rows), then Grand Totaled at the bottom of the spreadsheet. I have never had a problem...UNTIL RECENTLY. One of my columns is the time of day, such as 2:54pm, and presently, all of my inserted rows, except fo... 23 Mar 2010 00:09

How to prevent Cut&Paste to change style and data validation on protected sheet
Hi I would like to prevent that pasting to unlocked cells on a protected sheet changes the data validation and style. Is this possible? Thanks, PC ... 22 Mar 2010 10:32

How to prevent Cut&Paste to change style and data validation on protected sheet
Hi I would like to prevent that pasting to unlocked cells on a protected sheet changes the data validation and style. Is this possible? Thanks, PC ... 22 Mar 2010 10:32

Connect a number to a picture bank and import that picture to exce
I have a colum with numbers for specific products (example 111,123456) and I want a picture in the colum to the right of it that matches the number. On the computer I have a folder with pictures named with the product numbers. So my question is: Is there a function to link the the number in for example cell A... 22 Mar 2010 10:32

Syntax for stopping a Do Loop?
I have columns of data and recorded a macro for taking the average of every seven numerical entries. What syntax do I use to tell the macro to stop looping when it gets to a blank cell in the column? ... 22 Mar 2010 10:32

Protection
When I try to do anything in my sheet I get the message "the book was made exclusive by Burt" and I can't even save the sheet. Help ... 22 Mar 2010 08:17