View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich[_20_] Rich[_20_] is offline
external usenet poster
 
Posts: 8
Default Find cell select row and delete

Hi,

Can somebody please help

I have a worksheet with around 700 rows but always only 7 columns, once I apply a sort I have one blank cell in Column A. I have a macro that sorts and adds functionality to the sheet but I need to be able to find this empty cell in column A, select this row, select all rows underneath that contain numeric data and delete them. I am new to this so your patience is appreciated if I ask dumb questions
Many thanks in advance for your help

Rich