I am trying to remove the / from a date column and have the results formated
equally. For instance,  the original column has various dates fromatted
different ways such as, 3/8/1955 or 10/05/1985. I need a column with the
dates displayed with 6 numbers 03081955 and 10051985

I would like to have an if statment in my macro that would check the status
of a workbook, and if the workbook is Read Only do something else. I can do
the then and else of the statement, I'm just not sure how to perform the IF
part of the statement. So I think my question is ...

Since excel 2007 has over a million rows, if I have data on rows that the
previous versions of excel does not have and I send the spreadsheet to
someone with an older version, will they be able to make changes to the data
on the rows that the previous version doesn't have?  For ...

I have a spreadheet full of dates (ex:1/4/2003). i want only the month
portion to show in a different cell. The trouble is that the month portion is
to be shown as text (January - 1 is the month). I have managed to convert the
1 into January by using the Format-Cells command, but ...

For workbooks that are accessed only through a web page (like a custom
calculator) where there is no need to save changes, how can I skip clicking
No every time I close the page?
I've tried: If ThisWorkbook.ReadOnly Then ThisWorkbook.Saved = True

I have Excel 2000 9.0, and I'm trying to copy several worksheets into one
file.  I use the spreadsheets to do monthly budgets, so I have a month-end
worksheet, and weekly worksheets.  The month-end worksheet uses sums of the
weekly worksheet.  I would like to take all the "month ...

I have a function written in Excel 2003:
Sub Check_if_files_exist(path, fname, fileexists2)
   With Application.FileSearch
   .NewSearch

I have a column of numbers that are the results from formulas. in the absence
of enter values, the results column (say D) show several zeros.
I use =min(d1:d16) placed in column E to return the lowest value in the
colunm D which is ussually zero.

Is there a limit to how large an excel file can be? I have compiled several
charts and when I went to create a new graph and source the data the message:
"No new fonts may be added to this sheet" appears and prompts an error report
to be sent.

=OR(C:C="FLAT",C:C ="2FS",C:C ="3FCH")
Above is the formula I am trying, so column C words Flat, 2FS, or 3FCH will
get yellow highlight in another column cell. However, it now highlights the
entire column yellow, regardless of the text I have in column C. What am I

Similar to my previous post:
What is the difference between List Range & Criteria Range.
Is List Range the entire list we are pulling from, and the Criteria Range
what we are searching?

I would like to find unique values in a column, however the column is within
a larger list. (multiple columns) How do I identity unique values in that
specific column but pull out the entire row?

Hi there, thanks for all your help in advance.  I am looking for a formula
that will average every 3rd entry on a row of data.  I would like to set it
up so that it ignores empty cells.  chris

Since I started to use Excel 2007, my folders are getting loaded with .tmp
files that Excel does not seem to be deleting.  So I have to do it manually.  
A Google search revealed that there is some discussion on the AVG message
boards about the problem, and I do use the AVG virus ...

Can someone please help me with the VB code to put an X or an asterisk in
column A to indicate the activerow?
I'm running Excel 2003 from work and cannot utilize any downloaded add-ons.
I found several helpful posts instructing OP's how to highlight the entire