Combobox value apparently doesn't match cell value

[Dtex20]

Hi guys,

For Each cellImp In hideRange  
 If cellImp.Value = NoOfImpressionsBox.Value Then
     cellImp.EntireColumn.Hidden = False
   Else
     cellImp.EntireColumn.Hidden = True
   End If
Next cellImp

I've got a range ws.Range("BF4:BY4"), that gets pasted to a function. Both the value of "BF4" & NoOfImpressionsBox(combobox) are "1" i've checked with msgbox to make sure both variable return 1. However when running the code, they are not matching and the if statement is skipping. I've used the exact same processes elsewhere and it works.

Any suggestions?

Thanks guys!

 

[Fluff]

The combobox value will be a string rather than a number, which maybe the problem
try

If cellImp.Value = clng(NoOfImpressionsBox.Value) Then

 

[Dtex20]

The combobox value will be a string rather than a number, which maybe the problem
try

If cellImp.Value = clng(NoOfImpressionsBox.Value) Then

You're correct, i was wondering if was along those lines.

Works great now mate! thanks!

 

[Fluff]

Glad to help & thanks for the feedback