concatenate two cell to name new active sheet.

[Hardhat]

I am trying to pull data from to cells in a worksheet to name the tab of a new work sheet. I can make it work for data in one cell but not the two. Here is what i am using for the one

ActiveSheet.Name = Sheets(2).Range("A3").Offset(counter - 1, 0).Value 'name sheet

I would also like to have the Data from cell K3 as pat of the new work sheet name.

Chuck T

 

[Nine Zero]

try this

ActiveSheet.Name = Sheets(2).Range("A3").Offset(counter - 1, 0).Value & Sheets(2).Range("K3").Value

 

[Hardhat]

It did not work I even add the off set to the K3 value and it also faulted

ActiveSheet.Name = Sheets(2).Range("A3").Value & Sheets(2).Range("K3").Value.Offset(counter - 1, 0)

 

[Nine Zero]

hmm interesting... just tested it ... and it works fine....

Make sure in sheet2 there is actually a value in A3 plus the offset you are setting meaning is your counter is 50 make sure there is something in cell A52 of sheet 2 also in cell K3 of sheet2

if the error you get is a Run Time 1004 error then it means one of those or both is blank

 

[Hardhat]

Sorry it had taken me so long to get back on this. I was pulled away on some other projects. I made sure that I had not blank space from 1 to 52 in A and K rows. But I am still getting a runtim erroe 1004. below is what i have in the editor. the line above your code works fine for just the one cell to name the work sheet, but I would like both colum a and k as the name of the work sheet.

For counter = 1 To 3 ''Sheets(1).Range("f5").Value 'one loop per employee


Sheets(1).Copy After:=Sheets(2) 'copy the sheet


'ActiveSheet.Name = Sheets(2).Range("A3").Offset(counter - 1, 0).Value 'name sheet


ActiveSheet.Name = Sheets(2).Range("A3").Offset(counter - 1, 0).Value & Sheets(2).Range("K3").Value

 

[Fluff]

Duplicated on this thread https://www.mrexcel.com/forum/excel...f-else-conditional-statement.html#post5110669

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Please see rule 12 here: Forum Rules

As this has been resolved in the other thread I'm closing this one.