Thread: Save details
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WH99 WH99 is offline
external usenet poster
 
Posts: 51
Default Save details

I have the following code:

Private Sub CommandButton99_Click()

Dim iRow As Long
Dim FirstRow As Long
Dim LastRow As Long
Dim wks As Worksheet

For Each wks In Worksheets(Array("customers", "customers2"))
With wks
FirstRow = 2 'headers in row 1
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row

For iRow = FirstRow To LastRow Step 1
If Application.CountIf(.Range("a1").EntireColumn, _
.Cells(iRow, "A").Value) 1 Then
'it's a duplicate
.Rows(iRow).Delete
End If
Next iRow
End With
Next wks
End Sub

When I press command button1 it calls the code above. How can I insert to
save the details as well?
--
WH99