I have a spreadsheet where I have text in a cell. I created this file a few weeks ago and have been in and out of it several times with no problems. I was in it yesterday and made a few chan...
My Excel 2007 on Vista has started failing to open documents with the
error 'the system cannot find the file specified' when I double click on
an Excel file or Excel attachment. In Outlook...
I have an Excel spreadsheet with 9 charts on the first worksheet.
When it opens I don't want it to update and I don't want it to ask if I want to update it - what code do I need and where...
I have been looking for some time now for an Excel VBA version for calculating the total ISO Week count for a given month and year.
The function of days per month / 7 gives errors in some cas...
How can I dynamically create images on a UserForm using VBA from Images already loaded on a Worksheet?
NOTE: Loading from an external file is not an option.
My task is that I have 25 ...
Hi,
What is the code to make a negative number (-1) inside a cell display in "red" & "bold" based on the results of an IF function being true or false. Below is my formula which will display...
If I can do it manually, VBA can do it for me
see my code below
The "FitToPagesWide/Tall" is not working
How can I make my selection print as 1 page?
Thanks!
Hi
In Excel VBA I need to change the BackColor of a label on a form to either
red or green programatically.
How would you do this?
Is there way where you use an integer value that rep...
What is the VB code I would need to transfer data from one excel file to another?
I have an Access database which contains information I feed into an excel spreadsheet. I use Excel to present this information. However, some information needs to be fed back into Access. Quit...
I have an on errror handler in Excel VBA of the form:
on error goto doa
...application code...
exit sub
doa:
MsgBox ("Application.MemoryUsed=" & Application.MemoryUsed)
...
I would like to convert an Excel table (Column 1 are Product codes, Column 2 Sizes, Column 3 Quantities) to a Matrix (Column 1 product codes, then 1 column for each Size and the quantities bel...
I am looking to create an IF statement in Excel where the logical text looks for a particular word. I am writing the statement =IF((A2="Word"),T,F) but am getting #NAME? Can somebody let me kn...
I'm trying to insert the value of a string variable into sorting VBA code on my spreadsheet. This should be simple but I'm not getting it. The code in question is attached to this message.
R...
Hi
Is it possible to set all the pages in a Multipage control and then
use VBA code to set pages 2 and 6 as visible when needed.
Thanks
Hi
I learned how to create a list box with multiple option buttons. What do you have to do to do the same List box, but with multiple check boxes
The explanation I got for creating one w...
I need to generate a starting S Curve (Timephased at first, then Resource) only given the total number of hours, project task, and duration. I know that the starting S Curve will be just star...
How can I change the default paper size on excel 2007? I have the default A4 and want to change to letter. When I change it an re-opne excel it keeps putting the A4...
The first loop worked in Excel 2003, but randomly bombs since we upgraded to 2007. I changed the loop to reflect the second one below and it works fine now. I don't understand what would cau...
There is a answer in the db for this already (id 22085507) but I would like to further ask another question following on. I have a macro that I am using to open a calendar within the spreadshe...
I have made a custom contact form in Outlook. I need a script to allow me to select multiple Outlook contacts and put the contact information into a preformatted Excel spreadsheet. Here's th...
I need to know how in VBA to make a cell backgound and interior color chage to grey if it has a value of 0 and either one of the following cells have the word "Total" In it it.
Hello,
I have created this workbook for our organization that has all of the data in a sheet called All Data. the first sheet i started creating a look up where they can select the company ...
I have a column in Excel where some of the fields have text that is all capital letters such as the following:
NEWBORN DRIVE
I want to change the captial letters to:
Newborn Drive
...
Hi All!
Hopefully have an easy one today! Our company has an accounting calendar that differs from the traditional calendar. Not a big surprise! Our weeks always end on a Sunday and begi...
