Thread
:
Range Reference in Visual Basic
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Range Reference in Visual Basic
simplest would be
If Target.Address = "$F$5" or Target.Address = "$F$6" Then
or
intersect(target,range("f5:f6"))
--
Don Guillett
SalesAid Software
"John Baker" wrote in message
...
Hi:
I have the following worksheet based macro in VBA:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$5" Then
Run "buttonchange"
End If
End Sub
I want to expand the target address to F5 OR F6, and have no idea how to
do it. Whatever I
try $F$5:$F$6, $F$5 OR $F$6 or a myriad of variations around that come up
with a compile
error OR don't work!
Anyone got any thoughts on this?
Regards
John Baker
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]