targetval

  1. S

    Loop a VBA macro based off a dynamic range of cells?

    Hello, I wanted to know if anyone knows if this is possible. I am using Tushar Mehta's code Option Explicit Function RealEqual(A, B, Epsilon As Double) RealEqual = Abs(A - B) <= Epsilon End Function Function ExtendRslt(CurrRslt, NewVal, Separator) If CurrRslt = "" Then ExtendRslt...
  2. S

    Expanding on Tushar Mehta code?

    Hello, I was wondering if anyone could assist me in expanding on Tushar Mehta code for finding the possible values that would sum a total as my knowledge of VBA is very limited. As of now I have a list of data, and within that data I search to find what values may sum together to equal 0. The...
  3. S

    Solver combinations sum=0

    I was wondering if anyone knows a work around for the Solver add-in in Excel to use the sum value as 0... my function works for other numbers that I try but never completes correctly when it comes to finding combinations of my values that equate to 0. Example that I am using is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top