View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_7_] kirkm[_7_] is offline
external usenet poster
 
Posts: 91
Default Save & Restore a column


I've a requirement to save (and restore) an Excel column externally
The rows are 2 to the last one.

I would do this by using a For Next loop which writes each cell
content to a text file, and reads them back the same way.

However there may be a more sophisticated method using ranges
(which I barely understand), with a built in import/export routine?

If anyone has a better method than my loop/text file, would you
let me see it ?

Thanks - Kirk