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

End If

"Katrina" wrote in message
m...
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!