2007

Hiya Guys, Is there a way in EXL 2007 to automatically send an email out to a number of people, seperating the rows of the table that relates to that email address? To clarify: We extract a table of results from a system that includes individuals email addresses, and send a standard email...

Hi there! I have a user who has created a spreadsheet and wants to fix the charts in a particular position. When she places them in one position and saves the spreadsheet they appear to have moved the next time she opens the spreadsheet. Is there any way to fix them in a certain position...

Hi all, I need some help to solve a problem on an Excel 2007 spreadsheet. Basically, I have 12 columns with 47571 rows in, and what I'd like to do is run a macro that will automatically check every cell to see if the cell to the left of it is blank, and if so, will move the data in that cell...

Hey guys, need help on a very length code :eeek: I'm using Excel 2007. The way I programmed my Excel spreadsheet is: specific columns in a different worksheet ('Table') are hidden/shown according to answers in cells in worksheet 'Questions'. The code I included below is just a snippet of the...

I have recently had 3 instances where my error handling is not working the way I had intended. I am not sure whether these instances are related or three different problems. I have used error handling many times before and it has worked the way I intended it, so I am hoping this is not just my...

I use EXCEL 2007. I have small EXCEL spreadsheet (36 rows) that when I sort on two columns, crashes. Every time. I can add a worksheet and sort stuff on new worksheet, but the worksheet that crashes still crashes. This spreadsheet started at 1.3M, have been using it for years with few...

I have two pivot tables with the same report filters. I'd like to select the filters on one and then run a macro to make the same selections on the other. I've been able to do with with a single selection but if I want to select more than one item (2 or more states, for example) for one or...

Hi, I'm building an Excell 2007 workbook which has some data validation lists in the first worksheet ("lists"). These are standard statments and values which will be updated/changed from time to time. Then there are multiple worksheets (100+) with the same layout but containing variable...

HI there VBA Pro's I wrote some code in excel 2010, as seen below. Sub MyTest() Selection.ClearHyperlinks End Sub However when I run the code in Excel 2007 it does not work. what code can I use in 2007 to achieve the same result?

How to copy colours from another chart w/o changing the chart type in excel 2007? <HR style="BACKGROUND-COLOR: #ebebeb; COLOR: #ebebeb" SIZE=1><!-- / icon and title --><!-- message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->in...

I've been happily using the much improved conditional formatting that arrived with Excel 2007, but having just upgraded to 2010 it seems to have been broken again. I have conditional formats that remove the borders (defined using a cell style) from a small number of cells within a large column...

Hello All, I have a semi-complicated workbook that encompasses about 11 sheets all referencing one another. The main sheet is basically a sum of all the information from the other sheets. We are using this sheet to calculate the counters from the copy machine to charge each individual...

How do I write a macro that will save a 2003 version of a file (.xls) as a 2007 version (.xlsx)?

Hi All- I was looking for a link where there is a list of all the 2007 functions which are also available in 2003 but with different formulas. For instance; 2003 had SUMPRODUCT while 2007 has SUMIFS. Both of them are the same functions but different formulaes. Where can I find the list of...

Ok. I am new to this board but have been playing with VBA for a couple of years. A workbook I have developed over a year now randomly decides to crash. Sometimes it fails to find an object, like a userform, that absolutely exists! On restart excel usually finds unreadable data in the xlsb file...

Dear All, I am using Access 2007 and am at best an intermediate user so please be detailed in your response. I have a pivot table where I show the top 10 customers based on the sume of open sales orders. The fields are Customer Name and Sales. I added another instance of Sales and have the...

Hi everyone, I have a chart that is now displaying the NAs. It didn't used to in XL2000, but is in 2007. I have searched the net and can't find a solution. Can anyone here help please? I think it may also appear in 2003 at home: but this is a feint recollection since I don't usually use...

Hi, I have a simple macro that was built in Excel 2003. The macro simply takes the value of a cell and output it in another sheet. This runs for about 1000 lines. This used to take 5 sec with Excel 2003 but now takes forever with Excel 2007. Anyone can suggest an idea? I tried setting the...

I am not able to use two distinct macro shortcuts in the same sheet. I have reviewed the macros and they appear to be set up correctly, but only the 2nd of the two will run via its shortcut. Both will run form the Macros menu option. Can someone point me to a resource to troubleshoot why the...