Thread: If there are no values in row 37 delete it
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default If there are no values in row 37 delete it
Hi Himszy

Try this for the activesheet

If Application.CountA(Rows(37)) = 0 Then Rows(37).Delete


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Himszy" wrote in message . ..
Hi

How do I write a code that says that.

Thanks




Reply With QuoteReply With Quote