Thread: setting one worksheet cell range reference to another worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
  
Posts: 259
Default setting one worksheet cell range reference to another worksheet
Hi there

Try this in wrk2.("A1")

=IF(wrk1!$A1="","",wrk1!$A1)

Copy down to wrk2.("A10")

HTH
Mick

Reply With QuoteReply With Quote