title: Macro: How to locate the last row with data in a CSV file
body: <p>I am trying to copy some ranges of data from multiple Excel files and paste (by appending) into a single csv file. So, to append the data, I need to locate the last row in the csv file. 
  Is the way to locate the last row number in csv different the way to locate the last row number in excel as below?
  Cells(Rows.Count, "a").End(xlUp)
  If so, How can I locate the last row in csv? or do you have any suggestion in how to append ranges of data from different Excel files into a single csv file?</p>
  
  <p>Thank you very much,</p>