Copy past certain cells if cell is 1 to other sheet.

? From where to where, and what ?

I'm sorry!

I know the problem now. When you record in a sheet and run it in a other sheet it is running in the active sheet.
What i dont now yet is how to specific run it in the right sheet. For example i want this code only run in the Chemicalien sheet!

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Originally Posted by Fluff13

Try

Please Login or Register  to view this content.

I'm not home now. But when i put in front of a code it Will be for chemicaliën sheet only?

Yes, it will only copy the values on that sheet

I'm try te understand! Why is this not working?

Please Login or Register  to view this content.

and is this working

Please Login or Register  to view this content.

You need to add a period (.) before the Range with your code

So this should work but isn't working.

Please Login or Register  to view this content.

Should have put my brain in gear before making post#9

You can only use select on the active sheet. So that code will not work.
As I showed there is no need to select ranges, it only slows things down.

Originally Posted by Frigide

... So this should work but isn't working ...

As above Fluff13 ...
Is the "Chemicalien" sheet active at the time of copying ?
The reason may be "Selection" - "Returns the selected object in the active window for an Application object".
If another sheet is active than the one to which we refer, an error will be generated.

I solved this. I'm tying to learn how to write macro. I'm getting better and better. Bur lack of time because of a lack of a good tracking doc at work i'm asking allot.
I just record a Marco. It is doing exactly what i want. But it is copying the field instead of insert it. Because of that the last row is overwrite and i need that because it is my anchor for the charts. It has to insert with the same condition because of the conditional formatting!
Maybe i should make a new topic but here it goes!

Please Login or Register  to view this content.