View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Marty Marty is offline
external usenet poster
 
Posts: 116
Default 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.