Problem with Running VBA code on Cell Change
Thanks for the responses. I'll give it a go.
MARTY
"Lonnie M." wrote:
Hi, me again. I would think that something like this would work for
you:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim myRow&, myCol&
myRow = Target.Row
myCol = Target.Column
If myRow 6 And myRow < 31 Then
If myCol 4 And myCol < 9 Then
'your code here
End if
End if
End Sub
Good Luck--Lonnie M.
|