View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Mc James Mc is offline
external usenet poster
 
Posts: 2
Default Referring to a user-selected range

Can anyone advise how I can refer to a range in a spreadsheet that has
been selected by the user? Late in the macro, I need to loop through
all the cells in a range that the user selected earlier, and perform
an operation on each of them that depends on its location within the
range, but I can't figure out how to identify the range.

Thanks

James McIntosh
Australia