On sheet1, I have a web query which refreshes every 5 mins.
On sheet2, I want to copy the data (in rows) of the sheet1 before the
web query refreshes.....
I am dividing this question in two parts :

I have the following macro which I wish to run everytime the contents
of any cell is changed in the worksheet.
Could someone please advise?
Many thanks,

We are having some strange problems with SQL statemnts when users want
to edit a database request in MS Query.
First the user go to "Import External Data - "New Data request" (I don't
know the exact name for this since I haven't got an English Excel at

I have a userform with a textbox to put a starting number(txtStart) and a
textbox to put an ending number(txtEnd).  I also have 30 other textboxes
(Textbox1, Textbox2, etc) that I need to loop thru to see if there is a value
in the textbox  that matches the next number in the first ...

I am trying to copy Range A1, C1, D1 to Word Document
I have defined this as X
(like X= A1 & vbcrl & vbcrl & C1 & vbcrl & D1)
How I can apply the same font format in Word too?

Hello, all,
 Can you provide an example to illustrate how to connect sybase DB
with excel vba. I'll appreicate any reply for this thread.
 Thanks.

I want to open and work (read only) with an Access database from another
computer. How can I do this?

I have written the following code in order to iterate a discount rate from a
present value and yet it fails to recognise the values in the Target,
Period_Range and Cashflow_Range.  It works in another workbook but
unfortunately not the one in which I need it.  Can someone please ...

Say, I have a financial model that gives me a company value as an output. I
would like to carry-out a sensitivity analysis on any input value (growth,
discount factor, interest on debt, etc.)
The results would be presented in a table.

I need to hide the scroll bars from the bottom and right of the sheet.
I also need to hide the remaining sheets numbers from the bottom other then
the active page.
Can you please suggest what macro commands I shouls use to achieve this?

I need to transfer many different cells worth of data from man
different "Spares" workbooks into one "List" workbook.
I need this function to be automatic when the user clicks on
selection of buttons on "List". There will be different button

How do I hide any worksheets that are hidden.  In some of my macros, I am
creating worksheets in a workbook but at certain instances all of these
worksheets may not be created and others may.  I want to just specify unhide
all or hide all.

I have an excel workbook which contains several excel worksheets. Now I
have one macro for deleting perticular rows. But I want to run the macro
only on the one of the worksheets in the workbook which contains the
word "Vanessa". i.e, if any of the worksheets contains the data

I have the macro code below that follows the cursor and underlines the active
cell selection row to assist users. But this seems to kill any copy/paste
capability. Is there any easy way around this problem?
   Cells.Borders.LineStyle = xlNone

I daily save 10 to 20 text files which contain the following info:
Site XXXXXXX installed:
Master Cab Serial No: SWxxxxxxx
Master Cab PartNo: X7xxxxxxx