Hello~
I need assistance in construction a macro which will do the following:
- find a range of cells in colum A with data
- use that range of rows to search Columns B for any blank cells

Hi. I am having issues with learning the idea behind the SUMPRODUCT formula
instead of the SUMIF, as I do not want to have both workbooks open.  I have 2
workbooks, lets name them Workbook A and Workbook B, where Workbook A is my
information and Workbook B is more like a report ...

I would welcome some help with the following:
I would like the user to be able to perform the functions below, to all
the numbers in a range a cells i.e. B3 to E13 (this will not change) by
simply selecting an option or pressing a predefined button(s).

I wonder if you can help or point me in the right direction.
I have a sheet with a lot of information on it,  one of the columns i
a date column.  I would like to search though the sheet and copy al
data in a month to a sheet called that month.

I have a 'sumproduct' statement that works as a function when typed in an
individual cell - but I can't get a similar command to work inside of a Macro
     column A contains product type - e.g. radio, car, etc.
     column B contains product cost - e.g. $100.00

I am running Excel 2003 under Windows XP, and I want to do some data
validation when a cell is changed in the worksheet.  Using this example from
Visual Basic Help:
  Private Sub Worksheet_Change(ByVal Target as Range)

Regarding the inactivity timer that  Greg Wilson was helping another user
with....
I am unable to get this code to work.  Does it need a reference or is there
something missing here?

I need one on one  personal support for excel in Toronto, Canada

I am trying to use the OLE DB Provider for Jet 4.0 in .NET 2.0 to INSERT a
row of data into an Excel speadsheet. The problem I encounter is that there
is one column (the [Description] column) that I need to INSERT a lot of data
into, but I keep getting a "field is too small" ...

I'm using Excel 2003 and writing some VBA code to validate cell contents.
I'm using the "Worksheet_Change" event to trap when a user modifies the
contents of a cell ($1:$D).  If the contents are invalid I want to display a
message in another cell ($1:$C).  While stepping through ...

How can I set up a Static Time/Date stamp to be posted in a cell
whenever another specific cell has any information in it or is this
possible?  I never want the time or date to change.
Cell "A1" is empty until I enter info into it.  Probably text, not a

I have an issue that doesn't seem like it would be a big deal, but it is
causing major headaches.  I should say that I am using Excel 2003:
What I need to do is have a standard Excel document that a user can modify
to include text that will be replaced with information from a ...

I'm trying to read data from a worksheet, inputting it into an array,
and make SQL queries based on the array value, repeat for each value.
I'm having problems getting the array value into the query though.
Heres example code:

I have checkboxes on a worksheet from the Forms tool bar. The checkboxes are
in a named range on the sheet.
I want to loop through these checkboxes (the ones in the named range only)
and delete the ones that are checked along with the row that it sits on. I

I have this code in workbook#1
Global wb as workbook
sub dowhat()
  wb.activate      <<<< error here