variable inside an if formula vba help!@ easy fixi

[jordanburch]

HI All,

I have the below. It seems like an east fix I just can figure out the syntax. Can anyone help?
Its the variable parts that wrong and I cant figure it out. I keep trying different combinations with the variable inside the formula but can get it right.

Any ideas?

Jordan


Range("h2:h10000").SpecialCells(xlCellTypeVisible).Formula = "=+IF(RC[-6]=""" & Right(ThisWorkbook.Worksheets("Variables").Range("A10").Value, 2) & "/" & Left(ThisWorkbook.Worksheets("Variables").Range("A10").Value, 3) & """ , RC[-1],(RC[-1]*-1))"

 

[jordanburch]

That is a totally different & so needs a new thread. Have you got the formula sorted out?

No I gave up it makes more sense to do it this way seems simpler. I will create thanks!

 

[Fluff]

Ok.

 

[jordanburch]

Ok.

Hey Fluff. Any chance you can help here?

Help with Variables in array! Easy fix

Hey Guys, I have the below. I just cant figure the syntax out yet. Seems like an easy fix. I just want it to take the value and -1. ActiveSheet.Range("$A$1:$BA$10000").AutoFilter Field:=2, Criteria1:=Array( _ (Right(thisworkbook.worksheets("Variables").Range("A10").value, 2)-2)...

www.mrexcel.com

im under the gun on this one and keep trying different things and cant seem to figure it out! uggg!!
Any help is greatly appreciated!

Jordan