Renaming worksheets

[BERNARDYKIM]

Hey guys.
I have this worksheet with a list of people's names going down COLUMN A.
I want to be able to RENAME worksheets, starting from the fourth worksheet that is blank.

how do I go about doing this? I read through a lot of the forums for renaming worksheets, but I'm new to VBA and none address this variable in question.

appreciate any help from generous excel masters.

thanks!

 

[JLGWhiz]

Hey guys.
I have this worksheet with a list of people's names going down COLUMN A.
I want to be able to RENAME worksheets, starting from the fourth worksheet that is blank.

how do I go about doing this? I read through a lot of the forums for renaming worksheets, but I'm new to VBA and none address this variable in question.

appreciate any help from generous excel masters.

thanks!

Maybe this link will help you.

Excel Macros (VBA) tips for beginners: Change the worksheet name