View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
c4clark c4clark is offline
external usenet poster
 
Posts: 1
Default Using Ref edit in Add in to save to a different sheet.

Hey, I have built an Add In and want to be able to save to a different sheet
than the one I opened the tool on. It keeps giving me an error: SELECT METHOD
OF RANGE CLASS FAILED. This seems odd since the REf Edit has both the sheet
and the cell in it? Any suggestions?
--
Clare CLark