* :) * Can I copy and paste a value from the worksheet name (from the tab on bottom) and paste it somewhere on by worksheet with VBA?? How? Thanks!! *

[brad7989]

I have sheets that come in where I have each tab with unique names. There is one cell on each worksheet that I have to copy and paste the name of the worksheet on to (after my macro does a lot). Is there a way I can incorporate this part into my macro so I don't have to?

Thanks so much,

Brad

 

[VoG]

Maybe like this

Sub NameToCell()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
    ws.Range("A1").Value = ws.Name
Next ws
End Sub

 

[Rick Rothstein]

Something like this should work...

  Dim WS As Worksheet
  ....
  ....
  For Each WS In Worksheets
    WS.Range("A1").Value = WS.Name
  Next

 

[brad7989]

Cool! Thanks guys!