Hi, i need a macro that will save the workbook as html and insert an hyperlink in page and a script for password. I have the script, but i don't know how to...

I have the following formula in cell J7 =DATE(YEAR(H7),MONTH(H7)+6,DAY(H7)) This gives me a date in J7 that is 6 months forward from the date I will enter...

I tried to print out an Excel spreadsheet and only the color headings within the spreadsheet printed out. None of the B&W numbers in the individual cells...

Hi, I am creating a worksheet that will be completed by a number of people. I have a date formula A B ...

Well new to Office 2007 anyway. I posted this question in General Questions on 29th March - no reply as yet. If binary is more efficient speed and...

User enters a specific date, I'd like to round that entry to the end of the month

Trying to separate characters, and numbers from one cell into separate cells. I thought I knew the formual, but can't find it anywhere. Example in cell: 1...

Hi, Can you please help? Trying to look for words in a cell if it contains "FHA" then give me FHA. If it contains "VA" then give me VA. If it contains...

Is there a way to identify and clear only a certain subset of checkboxes on a worksheet? I've got the ActiveSheet.checkboxes.value = xlOff, but of course,...

Is there a way to format data so that when entering someone's height as 511 it will come up as 5'11" and when entering 63 it would come up as ...

how do i assign a value of a cell to a variable in a macro

I am trying to put Chart Title in header. I open the header, type in text, but text does not appear, not when I am typing and not when I try to display. I...

I have conditional format on a cell to format with say Fill Red ... It displays OK on the screen but doesn't appear when printed? I'm sure it'll be something...

Hello: Based on a person's "available date" I need to categorize that person as "0-30 days," "31 to 60 days," or " 60 days." Below is the formula I'm...

I have a worksheet originally created in excel2003 that gets external data from a db2 database. After migrating to excel2007 the external data in the...

i have a sheet with a running balance. This running balance is for all clients. I need a formula that will recalculate the running balance when i sort a...

Hi I have a bunch of graphs in an excel document. I use them in a lot of different power point presentations. I use the function copy/paste special/paste...

My original macro looked like this: Sheets("Inv_Load to Lawson").Select Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select ...

I currently have a Hyperlink table of contents listing each tab. This is listed in column C. I would like to match a cell (example E400) of each tab with...

I have an excel file of product information and I want to add an image to each, then mail merge it with a catalog letter. Is there a way to associate each...