View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vispy
 
Posts: n/a
Default Naming a sheet after a value in a cel of that sheet

Is there a way to name the sheet or a tab of the sheet with a value of a
cell on that sheet?


====== SNIP

Cells.Select
Selection.Copy
Windows("Verification.xls").Activate
ActiveSheet.Paste
Range("A1").Select
Sheets("Sheet6").Select
Sheets("Sheet6").Name = "2" <<<===== manually added but the value is
on cell D1 of that sheet.

====== SNIP

Thanks!!