Motorscooter
New Member
- Joined
- Nov 20, 2014
- Messages
- 9
I feel horrible for constantly posting questions in here. I am trying to write a macro that will copy cells from specific cells in a bunch of worksheets and pastes them into a new worksheet.
I am trying to debug it and I cant get past the "Sub or Function not Defined" Error. I tried starting from fresh and creating the macro in the Developer tool but I still get the error. Please help.
Thank you.
I am trying to debug it and I cant get past the "Sub or Function not Defined" Error. I tried starting from fresh and creating the macro in the Developer tool but I still get the error. Please help.
Code:
Sub copymacro()
Dim ws As Worksheet
Dim count As Integer
Worksheets.Add
Sheet(1).Name = "Copy Table"
count = 1
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
ws.Cells(3, 3).Copy Sheets("Copy Table").Cells(1, count).End(xlUp)(2)
ws.Range("C11:C32").Copy
Next
End Sub
Thank you.
Last edited by a moderator: