PDA

View Full Version : Modifying This Macro Slightly Please



Forex-Forex
01-24-2014, 09:11 PM
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
01-25-2014, 01:05 AM
crossposting with http://www.excelforum.com/excel-programming-vba-macros/984276-macro-button-with-embedded-variables.html