代码
'+ 5/9/9;995/<<?%#<?&%%#<?C#<?&%C?@
+ +/5/</?@99
8+ ..得到所有区域
,+ +/6&%/5/<?99
9
7、常用方法
根据单元格不同属性返回字符串数值
代码
'+ &$9/9/3/G&<39?9B99
+ 99999999/9G&9;9==@99
8+ 999999999<+/3C0<??9B99
,+ 9999999993+344NCONC56M(99
D+ 999999999999G&9;9+//3G&<?@99
E+ 999999999999:<G&+%<?+J&<==?PPG&+%<?+/<?K;"?99
+ 9999999999999999G&;=9=@99
F+ 999999999999$@99
+ 9999999993+344NCON6753(99
'"+ 999999999999G&9;9/+&:<+/6&%3G&<??@99
''+ 999999999999$@99
'+ 9999999993+344NCON574(99
'8+ 999999999999+3C0<3+344NCON6753?@99
',+ 999999999999G&9;9/+&:<+/6&%3G&<??@99
'D+ 999999999999$@99
'E+ 9999999993+344NCONQ46*(99
' + 999999999999G&;=9=@99
'F+ 999999999999$@99
'+ 9999999993+344NCONQ46(99
"+ 999999999999$@99
'+ 9999999993+344NCON555(99
+ 999999999999$@99
8+ 99999999:&(99
,+ 999999999999$@99
D+ 99999999A99
E+ 99999999&9G&@99
+ 9999A99
8、常用单元格边框格式
9
虚线 30+Q5)5N)CC)
实线 30+Q5)5NC6
代码