Hi, problem. a colum with numbers and formulas, what needs to be done to
get the average of just the numbers
col-1     col-2    col-3
5           5        10

I have to take regular screenshots of part of a Excel worksheet to post
to a website, and I'm getting sick of it!! Does anyone know a way to
automate taking a screenshot of a set range in a  worksheet, and saving
it as a local file (e.g. a GIF file), using VBA?

When I save a spreadsheet as an html file, cell that are set to "wordwrap"
display only the first line and there rest of the cell content is lost. Is
there any work-around for this?
Thanks,

I am trying to link a picture to a cell so when I do a v-lookup on another
sheet it will pull the picture to the new sheet.

I am trying to get help on a formula, I will try and explain what I need.
I have a spreasheet with a list of dates in column A and a list of dates in
column B (dd/mm/yyyy). What I would like is a formula in column C that will
either display Y or N (Y if the date in column A ...

I have a formula in a cell on a worksheet as follows:
=TEXT(DAY(B5),"00")&"-"&TEXT(MONTH(B5),"00")&"-"&RIGHT(TEXT(YEAR(B5),"00"),2)&"," & CELL("contents",D5)&""
I am attempting to automate entering the formula in a cell with the
following macro code. Obviously I have something ...

I have a spreadsheet I am working on and its pretty long and pretty
wide. Almost 200 lines. I was wondering if it is possible, in excel, to
set it up such that every alternate row is shaded.
I feel that this will help me when I am referencing the printout.

I have a list of email addresses in Excel and a document in Word that I want
to merge with those addresses and send as individual emails to multiple
people. I tried to follow the Excel instructions but couldn't get it to work.
 Any help would be appreciated very much.

I am making a big document for school in Excel that involves hyperlinks
to other worksheets and a menu. I work on a Mac OS X and use the Excel
X. The problem is that i create a hyper link to another worksheet,
everything is fine and lovely. the problem begins when i move the file

I have a worksheet with about 20 sheets or something and in every sheet
I have information that every now and then gets updated. The
information from the 20 sheets is summarized in a separate sheet.
The information in one column contains a number with some text, i.e.

In excel 97, when you did an export of a worksheet to a .txt file yo
were able to do an advanced options export.  Now I cannot find an
reference to this ability in 2002.  
Basically I have data that needs to be uploaded to a mainframe, and th

     Table A
     User ParameterA ParameterB ParameterC ParameterD ParameterE
     Jim x x x
     John x   x x

I'm currently running Microsoft Excell 2003 on Workstations running
WindowsXP. My network is both Windows 2000 and 2003. Suddenly my file names
are being changed from the names which were given and are not showing up as
numbers. Does anyone have any suggestion why this may be so.

I have two spreadsheets with several rows of data on each of them, they
both have header rows, with the same heading names. I want to copy the
data from spreadsheet 1 ( without the header row) to the spreadsheet 2
but keeping spreadsheet 2 original data ( i.e NOT REPLACE ) i just ...

Hi all, I just received an excel workbook where all the numbers have
been typed with an apostrophe    '    in front of them, therefore no
formulas work, i.e., the worksheet does not view them as numbers.
Going in to each cell and removing the apostrophe works, but the table