Using Worksheet_Change to Auto Run a Macro

  • Thread starter Thread starter Katrina
  • Start date Start date
K

Katrina

I've been doing a lot of searching today and cannot figure out my
problem.

Background: Using Excel 2002 and Windows XP. VB code opens Excel
file and dumps data into the workbook.

Once it dumps the data into the workbork I want to run a macro. I've
been trying to use Worksheet_Change to do this. Basically when a cell
changes (or has data dumped into it) I want my macro to run.

Here is a sample of the code I was trying to use:


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$N$6" Then
Call Macro2

End If

End Sub


I barely know what I'm doing so please be gentle with me.

Any help will be appreciated!
 
Your code worked fine for me in xl97 when I pasted into N6 alone. If you
paste into multiple cells (will fire if only pasting into N6 as well).

Private Sub Worksheet_Change(ByVal Target As Range)

If not Intersect(Target, Range("N6")) is nothing Then
Call Macro2

End If

End Sub
 
I might do it like this:
If Target.Address <> "$N$6" Then exit sub
Call Macro2

End If
 
Back
Top