This is the formula I'm using  =sum(E12*100)/F12.  If E12 is left
blank with no entry I get #DIV/0!.  How can I get rid of that result
without having to put a zero in E12?

I am exporting data from Access to Excel.  This part works great.  I
have the values exported to a worksheet.  I then link those cells to a
formatted worksheet within the workbook.  Since the data from Access
is dynamic, I don't always fill up the formatted sheet.  Therefore, I

I need help with this formula. Can't seem to figure out what I'm doing wrong:
=IF((F1="1 April 2008"),'[Dummy Forecast AprMayJun
2008.xls]Sheet1'!$E$22,IF((F1="1 May 2008"),'[Dummy Forecast AprMayJun
2008.xls]Sheet1'!$F$22,IF((F1="1 June 2008"),'[Dummy Forecast AprMayJun

I'm Allen.
Is there a macro that will allow me to update an exchange rate on excel
sheet, directly from some exchange rate website , once every 24 hours or any
other time interval?

Try to retrieve thevalue from 1 cell relative from named range.
Something like this.
Sub test()
   Set MyRange = Range("C1:F10")

I have 3 xls ex: exl1, exl2 & exl3, any data entered in exl1 of column  A and
data entered in exl2 of column D to be automatically added in column A of
exl3, kindly help pls........
TIA

In the following example:
Responsibility:  Name1 / Name2 / Name3
How would I extract out   Name1   in a macro and put it an an adjacent cell?
Thank you,

I have the following:
Range("Q1").Select
   Selection.NumberFormat = "dd/mm/yyyy"
later I have this:

I am trying to extract and use the column letter instead of the number.  My
code looks something like this:
Dim StrLastColumn as String
strLastColumn = ActiveCell.Column

Pls teach me the correct way to "return activecell's column header in
Alphabet".
In VBA:
Columns(1) represents column A

I am trying to make a reference to ISEVEN() in my Conditional Formatting.
However when I do this, Excel says that Conditional Formatting cannot make
reference to other worksheets or workbooks. I don't have this problem with
other IS.... functions, (e.g. ISERROR). When I look up ...

What I would like to do is have a macro to do the following.  Pick the FC
date and then go to the same date to the right and color & bold that cell
yellow and also color the two cells prior to that also yellow. Example:  
Color Yellow Oct 07 - Nov 07 - Dec 07 for FC date

I was hoping if someone could help me with a language problem I'm facing.  
The code below is suppose to extract strings from a worksheet and create
string table files that will be fed into a resrouce file.  I am using Excel
2007 currently.

I have 16 images each one inside one cell in an Excel Worksheet.
Each image is named: img1, img2, img3, ...
Every time a user clicks an image I want to call a VB function named
MyFunction and send the image ID and its position ... how can I do

I have a presorted Excel worksheet, & I'm trying to sort only the top part of
it from where I end up after the 1st sort (the 1st blank line after the top
part of the worksheet, but in tht middle of it[a daily variable starting
point]). This recorded macro & my attempt to get it ...