View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Excel VBA help to test the activecell.value

Perhaps you are on the wrong sheet

Try

With Worksheets("Sheet1").Range("I4")
If .Value = "W" Then GoTo WVEnumber
If .Value = "G" Then GoTo BIGnumber
If .Value = "F" Then GoTo BIFnumber
End With

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Marie" wrote in message
...
I am new to VBA macro's and can not get the following test to work
Range("I4").Select
If ActiveCell.Value = "W" Then GoTo WVEnumber
If ActiveCell.Value = "G" Then GoTo BIGnumber
If ActiveCell.Value = "F" Then GoTo BIFnumber

The Macro branches to WVEnumber - no matter what is in the cell "I4" - can
anyone help?