Thread: Set a cell from another worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Greg Greg is offline
external usenet poster
  
Posts: 331
Default Set a cell from another worksheet
This should be VERY simple. I'm trying to code VBA for the first time, and I
get a syntax error on the below statement. From all the tutorials I read,
this should work.
any clue?

Range(a99) ='[Book1.xls]Sheet1'!$B$1
Reply With QuoteReply With Quote