View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Yngve Yngve is offline
external usenet poster
 
Posts: 67
Default EntireRow.Delete, Causes Problems In ComboBox In Another Workbook

Hi Raleigh
try this

Sub a()


With ActiveSheet
Dim LastRow As Double
'countt columns A
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
Rows("1:" & LastRow).Select

End With
End Sub

Regards Yngve