本帖最后由 hackerbob 于 2022-4-5 16:29 编辑
出自吾爱论坛,由坛友在邮箱中收到
宏代码:- ' 0085 13 BOUNDSHEET : Sheet Information - worksheet or dialog sheet, visible - Shee
- ' 0085 14 BOUNDSHEET : Sheet Information - worksheet or dialog sheet, hidden -
- ' 0085 13 BOUNDSHEET : Sheet Information - worksheet or dialog sheet, hidden - Ufbd
- ' 0085 14 BOUNDSHEET : Sheet Information - worksheet or dialog sheet, hidden - Pdvse
- ' 0085 11 BOUNDSHEET : Sheet Information - Excel 4.0 macro sheet, hidden - DD
- ' 0085 15 BOUNDSHEET : Sheet Information - Excel 4.0 macro sheet, hidden - PKEBEB
- ' 002a 2 PRINTHEADERS : Print Row/Column Labels
- ' 002a 2 PRINTHEADERS : Print Row/Column Labels
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 002a 2 PRINTHEADERS : Print Row/Column Labels
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 002a 2 PRINTHEADERS : Print Row/Column Labels
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 00fd 10 LABELSST : Cell Value, String Constant/ SST
- ' 002a 2 PRINTHEADERS : Print Row/Column Labels
- ' 002a 2 PRINTHEADERS : Print Row/Column Labels
- ' Sheet,Reference,Formula,Value
- ' "",K4,"",1.00000000000000000000
- ' "",F7,"",3.00000000000000000000
- ' "",N13,"",2.00000000000000000000
- ' "",H20,"",8.00000000000000000000
- ' Ufbd,D5,T(Shee!P11&Shee!P15&Shee!B5&Shee!C3&Shee!C9&Shee!A12),""
- ' Ufbd,N6,T(Shee!E2&Shee!D17&Shee!F15&Shee!E6&Shee!E2&Shee!B18&Shee!G2&Shee!C9),""
- ' Ufbd,F11,T(Shee!E2&Shee!D7&Shee!P15&Shee!P7&Shee!P15&Shee!E11&Shee!F4&Shee!B15&Shee!D13),""
- ' Ufbd,P14,T(Shee!L2&Shee!P15&Shee!P7&Shee!P15&Shee!J6&Shee!J6&Shee!H9&Shee!H9&Shee!K14&Shee!K14&Shee!P15),""
- ' Ufbd,Q23,T(Shee!P2&Shee!M7),""
- ' Pdvse,E15,T(Shee!P19&Shee!P5&Shee!P5&Shee!P3&Shee!L11&Shee!M7&Shee!H4&Shee!G2&Shee!P5),""
- ' Pdvse,E23,T(Shee!E2&Shee!F10&Shee!D7&Shee!C9),""
- ' Pdvse,R24,T(Shee!P5&Shee!P5&Shee!P3&Shee!L11&Shee!M7&Shee!H4&Shee!G2&Shee!P5),""
- ' DD,D10,"CONCATENATE(Shee!F15,Shee!C9,Shee!C9,Shee!P15)",""
- ' PKEBEB,E9,"FORMULA(Shee!P22&Shee!H9&Shee!L2&Shee!B15&Shee!B15&Pdvse!D5&Pdvse!F11&DD!E23&Pdvse!N6&Shee!H4&Pdvse!P14&DD!L19&Pdvse!E17&DD!R24&PKEBEB!D10&DD!H18,E11)=FORMULA(Shee!P22&Shee!J11&Shee!B18&Shee!P11&"GRDS1"&DD!S7&Shee!H9&Shee!L2&Shee!B15&Shee!B15&Pdvse!D5&Pdvse!F11&DD!E23&Pdvse!N6&Shee!H4&Pdvse!P14&DD!L19&Pdvse!E19&DD!R24&PKEBEB!D10&DD!H18&Shee!P13,E13)=FORMULA(Shee!P22&Shee!J11&Shee!B18&Shee!P11&"GRDS2"&DD!S7&Shee!H9&Shee!L2&Shee!B15&Shee!B15&Pdvse!D5&Pdvse!F11&DD!E23&Pdvse!N6&Shee!H4&Pdvse!P14&DD!L19&Pdvse!G17&DD!R24&PKEBEB!D10&DD!H18&Shee!P13,E15)=FORMULA(Shee!P22&Shee!J11&Shee!B18&Shee!P11&"GRDS3"&DD!S7&Shee!H9&Shee!L2&Shee!B15&Shee!B15&Pdvse!D5&Pdvse!F11&DD!E23&Pdvse!N6&Shee!H4&Pdvse!P14&DD!L19&Pdvse!G19&DD!R24&PKEBEB!D10&DD!H18&Shee!P13,E17)=FORMULA(Shee!P22&Shee!J11&Shee!B18&Shee!P11&"GRDS4"&DD!S7&Shee!H9&Shee!L2&Shee!B15&Shee!B15&Pdvse!D5&Pdvse!F11&DD!E23&Pdvse!N6&Shee!H4&Pdvse!P14&DD!L19&Pdvse!I17&DD!R24&PKEBEB!D10&DD!H18&Shee!P13,E19)=FORMULA(Shee!P22&Shee!J11&Shee!B18&Shee!P11&"GRDS5"&DD!S7&Shee!H9&Shee!L2&Shee!B15&Shee!B15&Pdvse!D5&Pdvse!F11&DD!E23&Pdvse!N6&Shee!H4&Pdvse!P14&DD!L19&Pdvse!I19&DD!R24&PKEBEB!D10&DD!H18&Shee!P13,E21)=FORMULA(Shee!P22&Shee!J11&Shee!B18&Shee!P11&"GRDS6"&DD!S7&Shee!H9&Shee!B15&Shee!I17&Shee!I3&Shee!H13&Shee!P11&Shee!K9&Shee!P13&Shee!P7&Shee!P13,E23)=FORMULA(Shee!P22&Shee!H13&Shee!N4&Shee!H13&Shee!H9&Shee!P11&Shee!P15&Shee!H9&Shee!P20&DD!O14&DD!P10&DD!K6&Shee!P19&Pdvse!Q23&DD!E15&PKEBEB!D10&Shee!P13,E25)=FORMULA(Shee!P22&Shee!G41&Shee!P11&Shee!P13,E27)",""
复制代码
|