title: Macro to delete Rows containing #N/A
body: <p>I need help with the development of VBA Macro for Excel 2013.
  I work with large data files created after running a query macro to obtain data from a SQL server. The data file generated by the query file always have a a date:time stamp in Column A, and process results in the other columns (user pre-defined tags) the date:time stamp is essential because the data file is used by another application to analyze and generate reports. The raw data file contains at times a "0" value in some of the rows. A macro is run to remove the "0" values and copy value above.</p>
  
  <p>1st Scenario</p>
  
  <p>1st problem is, where data is not available for a date:time the data sheet displays #N/A in  cells. At times complete rows will display #N/A, with the time stamp in Column A. A Macro is then run to remove #N/A from the sheet. The sheet has then to be manually manipulated to delete the rows with no values except the time stamp.
  I need help with a Macro to delete rows that are empty except for column A with date:time stamp, the complete rows have to be deleted.</p>
  
  <p>2nd Scenario</p>
  
  <p>At times the #N/A will be in a column cell with values above, below, left and right of the cell, this #N/A row must not be deleted but must be the value above because of the other application data calculation.</p>
  
  <p>The manual manipulation of the data sheets is very time consuming, after the files are corrected it is saved as "csv" and imported to the other application.</p>
  
  <p>I have tried many conditional macros but no luck.</p>
  
  <p>Is there somebody that can help</p>
  
  <p>I will greatly appreciate any help.</p>