LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Macro Help ... Pass values to the excel based model and copy + pas

Hello all:

I have a big excel model which does some analysis.

I have to run the model on approx 150 different values and analyze the
results.

I need help to automate this process.

A macro that can:

1. Pass the values to the model (in Sheet1, cell A1 - from Sheet2, cells
A1:A150 - one at a time)
2. Wait for 10 seconds (to finish calculations)
3. Paste the values (values located on Sheet 1, A2: A10 into Sheet 3)

Thank you.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Help with VBA code for an Excel Model Macro [email protected] Excel Programming 5 March 21st 07 11:52 PM
Macro simplifying - copy rows to worksheets based on values in 2 different columns markx Excel Programming 1 February 27th 06 03:36 PM
badly struck! how to pass values from asp to excel VbUser25 Excel Programming 4 January 27th 05 12:58 PM
copy values based on date choice[_2_] Excel Programming 1 January 26th 05 04:51 AM
Excel macro script to copy only formulas and not values from one sheet to another Kate[_4_] Excel Programming 5 August 13th 04 12:45 AM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"