How to use variable in code

[BRC]

sub filldata

dim cap as long
' for purpose this of illustration F16= .15
cap = Sheet4.Range("f16").Value
' to verify that cap is initialized
Msgbox(cap)
' for purpose of illustration c6=.20
Range("d6").Formula = "=IF(c6<0,0,IF(c6>cap,cap,c6))"
end sub

If I replace "cap" with a number ( .15) it works fine but when I try to
use the variable cap I get a #name? error in the cells.
I believe I may not using correct punctuation around the variable. Any
suggestions Thanks
BRC

 

[Gary Keramidas]

you can try this

Range("d6").Formula = "=IF(c6<0,0,IF(c6>" & cap & "," & cap & ",c6))"

 

[BRC]

Sorry about that, I had removed the "long" from the dim statement. I
just had "dim cap " which I believe initializes a varient. Should I be
using something else there? Thanks

 

[Bob Phillips]

Yeah, if it will only be a number

Dim cap As Double

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[BRC]

Thank you all. The turning cap into a string worked. Thanks again. BRC