I have a work sheet with the date as the column header and hundreds of rows.
Most of the cells are blank but some contain values. Each value is coloured
due to the 'stage' it is in. Basically i want to read these 1000's of cells
and find all the values in red text. I already have ...

As part of a system a new tool bar was created in excel to allow the user to
use the system. The process which takes place is that a user creates a new
spreadsheet from access based on the criteria selected. The tool bar appears
automatically. The problem is that when a new ...

I need to open an Excel file using Interop, resize a column and then save
the file, insuring that the worksheet retains the newly resized column width.
As I step through the code all is working fine.  But when I reopen the file
the new column width has not been saved.  If I open ...

I'm searching the simplest way how to address uncontinuos (sub)range of
columns.
Imagine that you want to do something with columns 4 (= "D"), 7 (= "G"), 8
(= "H") and 12 (="L"). I'm trying to find something like:

Is there any way when a workbook is saved as that the new workbook doesn't
keep the code from the main workbook.
Thanks Mike

Why
Dim fogadrng As Range
Range("C8:C12,E8:E12,G8:G12,I8:I12,K8:K12").Select
Set fogadrng = Selection

Dear experts,
I am getting an overflow error type because I am not able to declare my
variables the way they should be (ex long).
I have a code like:

When I execute a Macro in Excel using this code:
Function FindTheFolder(ByVal way As String, _
                                   ByVal folderName As String) As Boolean
Dim theObject As Object

We have a .xls file on a server.  Is there any way to determine if another
user has the file open before trying to open it myself?

I created a macro that copies a set of data into a template.
Since the data vary in size, I had to make full column ranges so I
would always cover the cells with data. I also recorded a macro that
creates a formula based on two of those columns then copy/pastes the

I have about 100 files that have the same embedded macro in them. I
need to update one of the functions that is contained in the macro
code.
I know how to loop through all the files, open each one, and save/

I was wondering if there is a way to get excel to sort numerically as below
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11
rather than
1, 10, 11, 2, 3, 4, 5, 6, 7, 8, 9

Hi I have the following formula
=((A2*A3)+(B2*B3)+(C2*C3))/A1
how can I get the result ignoring #N/A for example if A2 = #N/A
Please help

I was trying to program a button with vba (excel) and got the following
advice:

IS THERE ANY MACRO TO EXPORTING DATA FROM EXCEL TO WORD WITHOUT GRID
LINES
THANKS IN ADVANCE
AKASH