Concatenating ranges in vba to use with GoalSeek !

[VBN00b]

Hi all,

I have been pretty good about teaching myself and this forum has helped millions!!!

I am stumped on this one though:

I have a matrix for some calculations that I am performing through a goal seek. I have five cases
A B C D E

I would like the values returned to be based off these case names that are in a drop down list as text in cell: Range("Case_Selected2").Value : which is A or B or C or D or E

So wherever there is a place in the code that is Range("Waterfall_Unadj_EV.A") for example. I would like to run it as something like

Please Login or Register  to view this content.

Is this possible?

[PingPing]

tout est possible!

Just capture the value using the Worksheet_Change event handler and concatenate it to your code. For example, try the following code in the CodeModule of the Worksheet containing the drop-down list (which, I assume, is the same worksheet containing the GoalSeek ranges).

Please Login or Register  to view this content.