Macro only runs when stepping through it

[terratushi]

Hi guys,

I'm quite new to VBA and I've been having a go at creating a macro which filters a sheet and copies the results to another sheet, whenever a user changes a particular cell. Basically, I have a drop down in cell B2 on a sheet called "CyBreakdown". Whenever the user selects from the drop down, I want the sheet "ACC" to be filtered and then the results are placed at cell A17 in the "CyBreakdown" sheet.

The code works fine when I step through it manually, however when I run the macro in full, it doesn't do anything. I'm not sure where I'm going wrong.

Here is the code I want to run:

Please Login or Register  to view this content.

And this is the code I have in the worksheet (CyBreakdown) when the dropdown in B2 is changed:

Please Login or Register  to view this content.

I don't know if it's something to do with the jumping between the code in the worksheet, and the code in a module?
Since I'm pasting data back into the "CyBreakdown" sheet, the macro jumps back to the worksheet code because there has been a change...?

Any input or advice would be great as I've been trying to do this myself and can't really figure out what to do, or if there is a much smarter way to do this!
Thanks

[bakerman2]

Please Login or Register  to view this content.

[terratushi]

Wow, that was very simple!! Can you explain why making it an absolute reference makes the difference?
Thanks

[bakerman2]

Because the result of Target.Address is also displayed as absolute reference.

Please Login or Register  to view this content.