How do you multiply two cells together without having an error message show
up? One cell has the amount shown in dollars, the other is just normal. The
formula doesn't shows up with errors, but don't know what formula i should
use.

Can anybody help explain why the following code does not work?
The value in range D2 is =TEXT($C$2,"DDDDDD"), c2 is todays date
   Dim rng As Range
   Set rng = ActiveSheet.Range("D2")

Hi Everyone!  I apologize that this was likely asked before but could
someone show me how I can copy my 'column headings, column widths and totals
formula' to a blank spreadsheet tab?  I have set up budget spreadsheet where
I input my receipts to keep track of monthly ...

I am finding a solution (formula) to automatically sum (3 or 12) cells
on the right after encountering first right cell greater than 0.
Currently, this is done manually. (eg. 3.9 is the sum of 2.9 (Aug) +
0.5 (Sep) + 0.4 (Oct).)

I have both excel 2003 and excell 2007 installed on my Vista machine.
I do most of my work in 2007 (and it was installed first)
I have some work I have done in 2003 that does not work properly in 2007
(Excel froms and moving data back and forth from Access to Excel)

I just opened a worksheet that has no external links and the majority
(80-90%) of the formulae have been replaced by #NA - basically my work has
been destroyed.
This has happened before with another sheet.  Both were large and complex

I need to set up color coding for five different conditions - can you help me?
if A1 cell value is greater than or equal to 6 then color yellow
if A1 cell value is between 5 and 6 then color silver
if A1 cell value is between 4 and 5 then color blue

Is it possible to create a formula that would automayically insert the
number of days in the current or previous month.  At present I am having to
manually insert the number into the formula, an axample below, month is where
I want the number inserting:

I have six checkboxes in a spreadsheet. Only one can be checked at any one
time. ie If checkbox one is checked and i need to change to checkbox two can
checkbox one be automatically unchecked.
Many thanks

I'm using a barcode scanner to input data into Excel.  The following is used
to create my timestamp.  Unfortunately, each time I scan, all the previous
entries scan with the most recent scan.  In other words, if I have 10 scans,
they all have the same date.  How do I ensure that ...

I'm trying to automate a worksheet. I have a command button that calls a
module,
(Module2), the code selects a range of cells (Range("A7:I7") and copies that
range

Hi, I am new to programming but I would like to rename sheets based on drop
down lists. For example: on sheet1 I have a drop down that contains 2
choices, 1A or 2A that you can select...based on which one you choose, I
would like the name of sheet2 to be updated to match your ...

i have created a vba project in excel long back. Now i would like to add few
modules now, how would i recover my forgotten password? please help me

This workbook with a half dozen worksheets keeps my checking account info.
The largest is the History sheet with 4100 rows, 9 columns, no calculation.
Next is the Current sheet with 700 rows, 9 columns, numerous calculations
including links to a "checks cleared" sheet .

I have a custom book.xlt and sheet.xlt in the C:\Program Files
\Microsoft Office\OFFICE11\XLSTART folder. Excel does use that if I
click on the "New" toolbar button or use CTRL+N while inside Excel.
But if I create a new Excel document from Windows Explorer (right