Running macros

M

Mike

Hi
I need help in getting a macro to run based on the value
of a cell. I have cells f3:ak3 changing to 1 at a
specific time, once the time changes i copy a formula
into the cells under f3:ak3. i have recorded a macro to
then copy and paste special formula to value so that i
can use the results in formulas. There are approx 80
stocks that i monitor and i would like to automate the
process.

regards
 
R

Richard Choate

Macros will only run because of an event. You have to do something to make
it run. the only solution that would approximate what you are talking about
would be to put a macro in the workbook_Change event, which will fire any
time you type something into a cell. It is very annoying to always have a
macro going off when you type. It slows things down.
Richard Choate

Hi
I need help in getting a macro to run based on the value
of a cell. I have cells f3:ak3 changing to 1 at a
specific time, once the time changes i copy a formula
into the cells under f3:ak3. i have recorded a macro to
then copy and paste special formula to value so that i
can use the results in formulas. There are approx 80
stocks that i monitor and i would like to automate the
process.

regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display formulae as values of each cell reference 7
Drop down list control value in vba 2
Copy addition formula of non-consecutive horizontal cells 2
Update specific cell at a specific time 6
VBA Coding Help for Beginner 0
Processing time 1
add or subtract every 5th column 2
Running macro operations in serial fashion 6

Top