Thread: Help with saving from a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
  
Posts: 789
Default Help with saving from a cell
Hi
Replace your definition of FileToSave with

FileToSave = Activeworkbook.Worksheets("HH1").Range("F2").Text

regards
Paul
PS I can't see any red text!

Reply With QuoteReply With Quote