Sub MakeRange()
For i = 3 To Sheet1.[A200].End(xlUp).Row
j = Sheet1.Cells(1, 100).End(xlToLeft).Column
ActiveWorkbook.Names.Add _
Name:=cells(i,1), _
RefersToR1C1:="=Sheet1!R"&i&"C2:R'&i&"c"&j
Next
End Sub
这个代码运行总是报语法错误,哪位大佬可以指点一下?感谢
谢谢大佬ï¼ï¼è½ç¶ä»£ç ä¸æ¥éäºï¼ä½æ¯ææä¹è¿æ¯åºä¸æ¥TTï¼è¯·é®æ¯ä»ä¹åå å¢ï¼å®ä¹åé½æ²¡ææå
追çé¦å è¿è¡æ¯å¦æ¥éï¼è¿ä¸æ¥è°è¯ï¼ççiãjå¼æ¯å¤å°ï¼cells(i,1)çå¼æ¯å¤å°ï¼æå¼ãå称管çå¨ãççæ¯å¦æè¿æ ·çå称