VBA Code Needed to track Multiple Variables

Reply #1

phileight — Fri, 13 Oct 2017 11:49:04 GMT

you don't provide enough info to give a specific answer

within back_3_success define a row and column where you want your result to be shown. ie rw=2:cl=3

if the variable a has the result then before you exit the sub insert cells(rw,cl)=a

if there is a loop involved (more than 1 result) then add a line that increments the row or column variable ex rw=rw+1 or cl=cl+1 or both

just put the code inside your loop

if you don't want to overwrite results from a previous test then after de... [ More ]

VBA Code Needed to track Multiple Variables

AllenB — Thu, 12 Oct 2017 14:00:43 GMT

I have Been Using the Following Code to Control a Macro.

Sub Run_Test()

'

' Run_Test

'

i = Range( _B3_Percent ).Value

Do While i 0.75

Back_3_Success

i = Range( _B3_Percent ).Value

Loop

End Sub

This Control Runs a Macro called Back_3_Success until The Range _B3_Percent is Greater that 75% and Stops.

What I need is to be able to Add a Macro Paste_Results into the process, so that the Results will be pasted and then the Run_Test Macro will Start again and Search... [ More ]