Run macro when a cell are changed

[chrotto]

I am trying to run a macro when cells are changing in a sheet.
The macro shall take a cell value from the active sheet and search for this value in a specific column in another sheet.
The code goes like this:

Please Login or Register  to view this content.

This code stops at

Please Login or Register  to view this content.

. Why?
When I run a macro with the same code manuelly it is working fine!

Hoping for help,
Christer

[npamcpp]

Hi,

if you want to manipulate or reference cells on a different sheet from a Worksheet_Change event, you need to qualify the reference properly.

It's not quite clear what the various "Select" statements refer to. Post a sample file and explain what you want to achieve. In most cases, you don't need to Select in code.

Something like this, maybe? But I'm only guessing at what you want to do, so please post more context.

Please Login or Register  to view this content.

[chrotto]

Hi!
Thank you for a quick and helpful reply.
When I first tried your suggestion it stoped on

Please Login or Register  to view this content.

When I changed this to

Please Login or Register  to view this content.

it worked fine.
/Christer

[npamcpp]

OK, in this case, you can make the code run faster without using .Select

Please Login or Register  to view this content.

Each .Select statement is another step in the procedure and takes its own time to process. Instead of selecting a value and then assigning the selection to a variable, you can assign the value directly to the variable, without stepping through select, as demonstrated above.

regards,