Sub Macro1()For i = 1 To 10Sheets(i).Name = Sheets(i).Range("B4")Next iEnd Sub
使用道具 举报
sheet1的代码为:
Private Sub Worksheet_Change(ByVal Target As Range)If Target.Row > 1 Or Target.Column > 1 Then Exit SubSheets(1).Name = Sheets(1).Range("A1")End Sub
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-6-4 01:40 , Processed in 0.190410 second(s), 5 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.