Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Worksheet_Change to Auto Run a Macro
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Worksheet_Change to Auto Run a Macro
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 -- Regards, Tom Ogilvy 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Worksheet_Change to Auto Run a Macro
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trigger Macro by Worksheet_Change | Excel Discussion (Misc queries) | |||
Worksheet_Change Event - Macro kills copy and paste | Excel Programming | |||
auto-filter change not triggering worksheet_change event | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming |