HI Everyone
I am new to VBA and I think my request is a simple one. I have a macro that will copy the sheet that I am on to a new sheet called table. the problem is I want it to be copied to a new line
This is my code
Code
Sub Copy()
‘Copy Macro
ActiveWindow.SmallScroll Down:=-6
Range("B4:B31").Select
Selection.Copy
Sheets("Table").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
End Sub
Display More
Any advice would be appreciated