Hi I have a bit of a prob,  I have one excel workbook with a data list
on it, and another workbook with another datalist on.   every piece of
data in column a workbook1 appears in colum a of book2, I need to find
the position of this data in column a from workbook 2 and copy columns

I am testing to see if the value on in a row is true and If it is true I
would like to paste the row to the next sheet on the first available blank
line.
For DLV = 2 to 1000

Below is a macro I am testing.  I am trying to create 26 command buttons,
starting with Commandbutton6, but a caption starting with number 1.  
Something is wrong with the "Activesheet.OLEObject" line and I don't know
what.

Using a macro, I would like to read the Conditional Formatting status of
cells so that I can, for example: color a sheets tab red if any cells on the
sheet are out of range based on their conditional format status. Attached is
code that I thought would do the trick. It works if I ...

For the life of me I can not remember how to add a variable name to a file
path.
I have converted a file from text to xls and have saved it as myfile - date
in mmddyy

I have a scheduling workbook template.  In this template workbook I need the
code to accomplish the following:
1) protect the template workbook so that it can never be changed,
2) code to create a new workbook via copying the template workbook.

I was wondering, and probably reaching for this one, if a macro can write
another macro and place it in the appropriate "Microsoft Excel Object" sheet?
The project I am working on is a annual scheduling workbook that will create
26 sheets (payperiods) when a commandbutton is ...

I need convert time 10:20:24 into minutes so that I can divided a number to
determine how many units are being done a minute.
I don't know how to do this.
Please help

I have a pivot and I need to refresh data every same time, but I haven't to
select the refresh every check box, because it's hide

Refering to the post under Excel Worksheet Functions
Does anyone have any suggestions on following macro coding?
[Working]
With Sheets("Temp").QueryTables.Add(Connection:= _

I have date in cell a1 with dd-mmm-yy format.
On the same sheet, I have another cell with "Allocation for " & A1
The result gives me Allocation for 39512
Required result is Allocation for 05-Mar-08

In the following macro in excel please answer the italic question
Range("A1").Select
   Selection.End(xlDown).Select
   Selection.End(xlDown).Select

I'm sure this is an easy question for most, except for me!  I have an
InputBox that gets a value and then copies the number down.  Numbers will
already be in the
column from the prior week, and could be used again.  However, if the user

I have workbook which has a number of reference worksheets that need to be
hidden from the users view.
Those sheets need to be referred to by a UserForm as part of drop down lists
and other validations.

Since I cannot run a macro to query cell(s) for Conditional Formatting
results, can I query for Data Validation results? I have 40+ sheets in my
workbook and I would like to set the Sheet Tab colors to indicate whether a
sheet has out of limit data in any cell on the sheet.