Active sheet issues

[tahano54]

hi all and thank you in advance
Specific issue: based on values in col 1 on sheet "dec" i want to copy data off of sheet "bin" and paste to sheet 3. I have researched and am using the activate option as shown in the pic. this command takes and i assume the sheet "bin" becomes the active sheet. the next line is intended to select a range of cells on that sheet but what happens is that the cells in the range option refer to values on sheet "dec" according to the correct row and col index and not what i presume to be the active sheet.
what am i missing?Picture3.gif
thank you

[Norie]

Instead of activating worksheets make sure you fully reference anything, then you can be guaranteed the correct sheets are being referred to.

If you want to know what I mean post your code and I'll try and show you.

By the way, where is the code located?

If it's in a worksheet module any reference to a range will refer to a range on the worksheet whose module the code is in.

For example, if this was in the Sheet1 module it would refer to A1:B20 on Sheet1, no matter which sheet was active.

Please Login or Register  to view this content.