VBA How to run a sheet from another sheet

[Palucci]

Something happened to my macro. I have a problem . I have a sheet with buttons for all "TO DO MACRO" macros. However, as for one, I press the button. I get an error "Method Select class Range ... 1004", but when I start from the sheet where the macro is, everything is ok. How to make it start from another sheet. Below is part where is bug its shown.

Set wbMe = ActiveWorkbook
wbMe.Sheets("input_forecast").Rows("1:1").Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    Selection.NumberFormat = "YYYY-MM-DD"

 

[DanteAmor]

Try this:

Sub Macro()
  Dim wbMe As Workbook
  
  Set wbMe = ActiveWorkbook
  With wbMe.Sheets("input_forecast").Rows("1:1")
    .Copy
    .PasteSpecial Paste:=xlPasteValues
    .NumberFormat = "YYYY-MM-DD"
  End With
  Application.CutCopyMode = False
End Sub

 

[GWteB]

You cannot select anything on a sheet which is not the active one. So change your code like below and it's most likely to work.

Set wbMe = ActiveWorkbook
    Set rng = wbMe.Sheets("input_forecast").Rows("1:1")
    rng.Copy
    rng.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
    rng.NumberFormat = "YYYY-MM-DD"