its not a vba problem, i just want use fomula to get this down
informations inside the file. than
+-------------------------------------------------------------------

I would like to know how I can get the colour of a row to automatically
change when a certain value is input, or any value at all into that
column.
Thanks

I would like to write a macro that asks the user to select multiple cells on
a sheet (i.e. D10,AK13,AG16,V19) using an InputBox or similar. Then I would
like the macro to cycle through each of the cells using the cell contents as
a string in some other statements.

When stepping through a macro where values are being changed ( e.g.as in a
loop) is it possible to "see" the current values.
For Example :-
For x= 1 to 19

Hi, I have a columns labelles A B C D E  under which are numbers. Is
there a way, in combinations of 3, to work out all the possible
combinations that = a certain total using vba.
eg, ABC, ABD, ABE......ETC. At the momment Im using varaiables and

who kowns how to write a VBA to show users user name and ip address,
window type in column a1?

I have a macro that pulls information from a word file but can't get to the
Header string.
In word2003, I can get the following vba command to pull the text from the
header.  The question is how to run this command from within Excel.

While macro is executing. how do I get VBA to automatically select either
"YES” or “OK” whenever any dialog box pops up asking for user input? I just
need VBA to automatically accept any “YES” as well as “OK”, which pops up
during execution of macro.

i keep getting an error (object required )
   Arr(i, 1).Value = ActiveCell.Value
Why?  where have i gone wrong?
--------------------------------------------------

I've got a macro that executes when the spreadsheet is opened.  Is there a
way to set this marco to execute for any spreadsheet that is opened on my
machine?  Not just the one that has the macro embeddid in it?

I currently started a web-based business and need to create a system to track
all customer information, including payment information and transaction
information/tracking.
I also wanted to include a way to track the demographics of my customers

First, I need to know if you can set a conditionnal formatting based o
the data in a cell other than the cell you are formatting.
I have two columns: one is, for instance, indicating the type of dat
(Req, Info or Guide). I wish for the cell right to it, in the nex

Hie, I am trying to write a macro to sort rows of data according to th
key in a specific column. Below is the code to sort the rows of dat
according to the key in column E:
Sub ColumnE()

I've written out the following code but when I try and reference it
later on in the code, it keeps telling me 'Object Required'.
Sub AddNew()
Dim NewBook As Workbook

All-
I want to integrate some code to make a cell to fill green when on-time is
scheduled and fill red if it is not scheduled.
Thanks in advance!