Excel VBA help to test the activecell.value
If EVEnumber, BIGnumber, & BIFnumber are range names then go to them by
selecting or activating that range:
If ActiveCell.Value = "W" Then Range("WVEnumber").Select ' or activate
Alan
"Marie" wrote:
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?
|