Need Macro help to exclude one worksheet

Hey guys;

I have the following macro that pulls data from all worksheets and pastes into a master worksheet. It works great, however I have one worksheet that I do not want this macro to copy from. How do I exclude this one worksheet?

Sub Merge()
Dim ws As Worksheet
ActiveSheet.UsedRange.Offset(0).Clear
For Each ws In ActiveWorkbook.Worksheets
If ws.Name <> ActiveSheet.Name Then
ws.UsedRange.Offset(4).Copy
With Range("A65536").End(xlUp).Offset(1, 0)
.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End With
End If
Next
End Sub

Try the following. Replace ("WorkSheetToIgnore") with the name of your sheet. Please use code tags when posting any code.

Please Login or Register  to view this content.

I recieved the following error when trying to complete this:

Untitled.png

Could you post a copy of your file including the code you have so far? It would make it easier to see what's going on.