Identify Spreadsheet and change the Spreadsheet name?

[nonono]

As you can see in the image, as I import some document into the excel spreadsheet it will be name "xxxx"
I would like to automate the process where it will automatically change the spreadsheet name.

If document row is from Row 'A' to Row 'H'change spreadsheet name to "Tester Utilization"
else if
If document row is from Row 'A' to Row 'U' change spreadsheet name to "Lot History"
else if
If document row is from Row 'A' to Row 'L' change spreadsheet name to "Lot Operation Report"
else
If document row does not match the criteria above, change spreadsheet name to "Unknown"

*Hope it does not identify the other spreadsheets, while it changing the spreadsheet name. The other spreadsheet names are "Menu", "Original (2)", "UTP", "Original" and must not be change....

 

[My Aswer Is This]

Try this:
I assume you mean Row One columns A To H for example
We have no rows A To H
We have rows 1 to 20 for example

Sub Row_One_Count()
'Modified 7/25/2018 10:25 PM  EDT
Dim lastcolumn As Long
lastcolumn = Cells(1, Columns.Count).End(xlToLeft).Column
If lastcolumn = 8 Then ActiveSheet.Name = "Tester Utilization"
If lastcolumn = 21 Then ActiveSheet.Name = "Lot History"
If lastcolumn = 12 Then ActiveSheet.Name = "Lot Operation Report"
End Sub

 

[nonono]

Maybe it might be just me but I have copy paste the macro in my visual basic and tried to run the macro but nothing seems to be happening?

 

[My Aswer Is This]

You said:

If document row is from ​

Row 'A' to Row 'H

'change spreadsheet name to "​

Tester Utilization

"​

To start with we have no such thing as Row A Or Row H

So tell me again what you want.

We have rows like row 1 and row 2
We have columns A and B and C

 

[nonono]

Now I understand why it didnt work because in the image above "Lot History" there is only 20 column
Not 21 ... excluding the "U" column

Anyway thank you.. for your time sir
Am appreciate it <3

 

[My Aswer Is This]

Now I understand why it didnt work because in the image above "Lot History" there is only 20 column
Not 21 ... excluding the "U" column

Anyway thank you.. for your time sir
Am appreciate it <3

So I now believe your saying it works

It looks in Row(1) to find last value

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.