VBA Runtime 1004 error - How to change sheets?

[DataBlake]

Hello all,
I'm having a problem where i try to run a column moving macro using

    Worksheets("MHT").Activate

 Dim lastRow As Long
 lastRow = Range("A" & Rows.Count).End(xlUp).Row


    Columns("F:F").Select
    Selection.Cut
    Columns("A:A").Select
    Selection.Insert Shift:=xlToRight

the issue is that im running the macro from another sheet
if i remove the worksheet activate or select the code works perfectly
how can i start this macro from any other sheet and it go to the one i want it to and perform the column moving?

any help is greatly appreciated.

 

[Fluff]

I cannot replicate your problems, so not sure what to suggest.

 

[DataBlake]

I cannot replicate your problems, so not sure what to suggest.

alright, well thanks for trying. i know how to work around it i just hope endusers can follow directions.

 

[Fluff]

i just hope endusers can follow directions.

They can definitely follow instructions, the problem is they never do