Thread: Entirerow.delete based on multiple cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
tom[_7_] tom[_7_] is offline
external usenet poster
  
Posts: 24
Default Entirerow.delete based on multiple cells
Nevermind - you were missing the .row, i.e.

Dim lastrow As Long
lastrow = Cells(Rows.Count, "ar").End(xlUp) .ROW

Thanks for your help.

-tom

Reply With QuoteReply With Quote