View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
murthy murthy is offline
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.