example:
   cell F1 is the start date   07-01-06
   cell E1 is the end date 07-29-06
   cell F3 is the answer  4

My code copies a summary sheet from one workbook into another, and the
copied sheet contains links that I want to get rid of and formulae that I
want to keep.  I have tried various ways to get rid of the links, but have
been unsuccessful so far.  I get a runtime error 1004 ...

I have a list of partnumbers in column A.
This partnumbers can be numbers and/of letters.
Example: Cell A22 contains 123ABC
My fill-in cell to find partnumbers is B1, next to that cell is a

I have the following code in my work sheet (Excel 2003) for the purpose of
running a macro when a cell value is 1.  This value is being moved into
another cell via OPC from Rockwell Software RSLinx.  The macro saves a copy
of the workbook as the current date and time.  The macro ...

I am trying to hide rows with a specific value.
In my sheet I have three columns:
Date - The manually inputted date
Today - 1 Month - 'TODAY() -31' (this column will be hidden)

i am trying to compare the contents of all the cells in column a with all
the cells in column b and where there is a match copy that name to column c.
the problem is the name in , for example,  A10 may exist in B1620 and i have
16000 cells to compare. hope i've explained this ok.

I have a line in a macro as follows:
Sheets("Chrono").[A1] = Format ((Timer() - Depart) / 3600 / 24, "hh:mm:ss")
When I try to run the macro I get the following error message:
Compile Error:  Can't find project or library.

Having managed to create a reporting tool, first attempt at excel VBA, my
manager now wants an update built in. I thought the easiest way would be to
call the Standard Form from the Data tab. Although by simply highlighting the
cells, and selecting from the drop down lis, my code ...

Hi. I want to fetch the address of the active cell so that I can use the
reference to build a formula. I have tried some, but so far I only got the
value of the active cell, and that doesn't help me at all.

Following on from Parts 2 and 1.......!!! See previous questions of the same
title.
Bob Phillips provided me with the following code:
Range(Cells(1, 17), Cells(LastRow, 17)).FormulaR1C1 =  _

I am trying to make a macro that will create dynamic named ranges
since i have 500 of them to make 25 per worksheet for 24 worksheets.
i want it such that each time we hadd a row or multiple rows to the
worksheet it will update the range.

I am using the following formula, kindly provided on this forum) to return
some code from a string in cell D1
=MID(D1,FIND(".",D1,1)-1,3)
However when I try to use this  to set the formula  in column F using VBA

Thanks in advance,
I have a problem when ttrying to use the range.replace method in excel. If I
have left the find/replace environment in "within" "Workbook" mode and run my
VBA code. The routine will update the entire workbook instead of the selected

I have 2 spreadsheets, dailydata and datamonth. I need a macro which looks up
the date in dailydata which is in a fixed location, and then finds the
matching date in datamonth across a row of monthly dates (e.g. 01 jul to 31
jul) and pastes values from dailydata below the ...

I have a issue with number formatting, in India we use thousand
separator as below, we do not follow million style of for using commas
instead we follow Lakhs format. I tried many permutations and
combinations in format cells-> custom formatting but I am not getting