variable variable based on other variables?!

[witham]

Hi All,

If I wanted to state a variables value based on another variable, how could I do that?

The two variables I current have in the script are

Dim Red as Long
Dim Green as Long
Dim Amber as Long

Green = Sheets("HURDLES").Range("C5").Value
Red = Sheets("HURDLES").Range("E5").Value

What I want to achieve is establish Amber as being between Green +1 & Red -1

Any help appreciated!

 

[AlphaFrog]

Perhaps something like this...

Amber = Application.Average(Green, Red)

 

[witham]

Hmm, not sure that will do it AlphaFrog, it is a definite range between the red and green, not an average of them.

 

[RoryA]

A Long can only be one value, not a range. What exactly are you trying to do?

 

[AlphaFrog]

it is a definite range between the red and green

I don't understand what that means.

Amber = Abs(Green-Red)

This will calculate the absolute difference. That is sort of a range. Is that what you want?

 

[witham]

Hi Guys,

I think I sorted it a different way. I can see how it cannot be a range so I sorted it with an IF, IF greater than Red & less than Green.
That seems to have sorted it.

Thank you for your help!