Hi...I was wondering if someone could help me. I would like to copy only columns A thru L from the worksheet labelled "Master" and not the entire row since columns M and onward are helper columns. I tried change the range but keep getting an error message. I have attached to code below that works for copying the entire rows. Thnaks

Private Sub Macro()
Dim d As String
Dim x As String
Dim i As Long
Dim y As Long
Range("C1").Value = GenericBrand
cboGenericBrand = Empty

x = cboGenericName

Sheets.Add.Name = x


d = Range("C1").Value

i = 1
Do Until ActiveCell.Value = d
Cells(1, i).Select

i = i + 1

Rows(1).Copy Sheets(x).Range("A" & Rows.Count).End(3)(2)
Sheets(x).Range("A1").EntireRow.Delete shift:=xlUp


For y = 2 To 40000
If Cells(y, ActiveCell.Column) = x Then
Cells(y, ActiveCell.Column).EntireRow.Copy Sheets(x).Range("A" & Rows.Count).End(3)(2)
End If

Next y


Do Until Cells(1, 1) <> ""
Cells(1, 1).Select
Cells(1, 1).EntireColumn.Delete shift:=xlToRight
End Sub