Forum Discussion
Solved
Macro on non active sheet
Hello, I am very new to VBA coding and I am having some problems with a VBA code which I found online: Sub Create() Dim I As Long Dim xNumber As Integer Dim xName As String Dim xActiveSheet...
Change the line in the middle to this, and it should work.
Set xActiveSheet = Sheets("Copy")To put a button on the INPUT sheet, select it from the "toolbox" on the Developer ribbon and assign the macro to it.
Change the line in the middle to this, and it should work.
Set xActiveSheet = Sheets("Copy")To put a button on the INPUT sheet, select it from the "toolbox" on the Developer ribbon and assign the macro to it.