Moving Column to Separate Sheet Macro

[MikeTruth]

I have recorded the macro and yet it will not perform the task. I am copying a clomun from sheet 1 A2-A351 and pasting it to column B2-B351 in sheet 2. Here is my code:

Please Login or Register  to view this content.

However it keeps giving me an error message of "selection method of range class failed" and when I choose to debug it highlights

Please Login or Register  to view this content.

I do not know what to adjust or debug because the macro seems simple, Possible solutions anyone to solve my macro anyone?

[TMS]

Is Sheet2 protected?

You could just use:

Please Login or Register  to view this content.

However, if the sheet is protected you'll face the same problem


Regards, TMS

[JosephP]

if that code is in a commandbutton_click event the range you are trying to select is on the same sheet as the button. if the code has previously made another sheet active, it will fail with the error you mention.