View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matthew Scheperle Matthew Scheperle is offline
external usenet poster
 
Posts: 3
Default Export range to text file

I need to export a range from excel to a text file with a delimiter such as a
comma or semicolon. I want to be able to have some kind of macro that will
check each row and if a row is blank then it will stop there and only export
the rows that has data. Which is why I was thinking of using a range, or
array.

I do have some formulas in the cells so do not want that to show up in the
export.

Thanks,
--
Matt Scheperle