Modifying This Macro Slightly Please

[Forex-Forex]

Dear Excel Community

This is my first post on this wonderful forum.

Attached is a macro. I need the following modification please

◘On the Analysis Tab, can we in Column I have an embedded table that will allow us to change the parameters in the macro:

ElseIf Abs(WorksheetFunction.Sum(c.Offset(0, 5))) >= 1000 And _
Abs(WorksheetFunction.Sum(c.Offset(0, 6))) >= 0.01 Then

I may need to change the 1000 or 0.01 easily to other numbers so if I change the parameters and click RUN Button it will update the Analysis Tab

◘Also have a RUN Button to have this working work

Thanks a million

[patel]

crossposting with http://www.excelforum.com/excel-prog...variables.html