View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
glenn glenn is offline
external usenet poster
 
Posts: 122
Default referencing previously selected cells after macro execution begins

Apologies in advance for this stupid question. I am attempting to write a
short macro for a co-worker that allows a user to select a range of
spreadsheet data then save the selected data to a text file. How do you
select the data then start the macro and reference the selected data within
the macro? Everything I've tried chokes during debug. The operation seems
trivial but apparently to this old boy , isn't.