I've found some great data here for using VBA to title my worksheets based on a cell's text value. But is there a way to use VBA to base a worksheet name on two different cells' text values? That is, to just combine the text of the two source cells?
Sub tabname() Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Name = ws.Range("A4") & ws.Range("B4")
Next
End Sub
I take it you want to name it based on the range in each individual sheet? These are details we need when you are initially posting.
Code:Sub tabname() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Name = ws.Range("A4") & ws.Range("B4") Next End Sub