I would like to be able to save the worksheets name and use it as a bookmark in a word document.
This is what I have so far:
Dim ws As Worksheet
Dim ws1, ws2, ws3, ws4, ws5, ws6, ws7, ws8, ws9 As String
Set ws = ThisWorkbook.Sheets("CNE")
ws1 = ThisWorkbook.Sheets("CNE")
The setting part work great. But I want ws1 to equal the worksheets name. so it can be placed in a word document like so:
.Bookmarks("SR_Title").Range.Text = ws1 & "_HRS" 'Bookmark 12
Any thought son how to do this?