Thread: I need to return the name of a worksheet in another worksheet cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
abcd[_2_] abcd[_2_] is offline
external usenet poster
  
Posts: 52
Default I need to return the name of a worksheet in another worksheetcell?
dim Sh as worksheet, r as range
Set R = Range("A5")
for each Sh in Sheets
R.value = Sh.name
set R = R.offset(1,0)
next
Reply With QuoteReply With Quote