Worksheet.Change to Auto Run Macro

[bobina]

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!

 

[SkipVought]

Hi,

So you want this procedure to run EVERY TIME a cell is changed on

any sheet OR

only one sheet?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[bobina]

Every time a cell is changed on one specific sheet.

VB will open the file read-only and dump the data. My Target.Address is first cell data will be dumped into. VB copies a table and chart from the file and then closes it.

Nothing is saved.

Does that help?

 

[SkipVought]

Then in that sheet's worksheet_change event, call your macro just as you originally posted. I don't understand the problem.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[bobina]

The problem is nothing happens.

Do you know of any reason why it wouldn't work?

 

[SkipVought]

Where does Macro2 reside with repect to the worksheet that you are dumping into?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[bobina]

The worksheet that I am dumping into is "Measurement Data", Macro2 resides in worksheet "Measurement Table" (or Module2).

 

[SkipVought]

Put your macro in a module NOT in a worksheet object

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com