请教excel vba高手,在赋予单元格公式时,有单引号(即一个"),该怎么编写?

2025-03-26 02:46:39
推荐回答(1个)
回答1:

Range("a7") = "=text(a6," & Chr(34) & "yymmdd" & Chr(34) & ")&text(counta(学号!a4:a65536)," & Chr(34) & "000" & Chr(34) & ")"