Thread: How do I do a VBA comparison to a financial value (i.e. $10000)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kletcho Kletcho is offline
external usenet poster
  
Posts: 36
Default How do I do a VBA comparison to a financial value (i.e. $10000)
You're pretty close. Try:

If ActiveCell.Offset(0, -1).Value 10,000 Then
ActiveCell.Value = 1
End If

The formatting really doesn't make a difference when you use .value
(unless it is an actual text value and not a number)

Reply With QuoteReply With Quote