Скажем, у меня есть очень длинная формула в одной из моих ячеек в Excel:
= If (sum (d3: d6)> 1, "A-b-c-d-e-f-g-j-j-k-l-m-n-p-q-r-s-t-u-й-x-z 01", if (sum (d3: d6)> 1, "A-b-c-e-g-h-j-k-n-m-n-p-p-d-r-s-й-й-z-----------------------------------------------ни--не-j--------- -V-W-X-Y-Z 03", IF(SUM(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 04", IF(SUM(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 05", IF(SUM(D3:D6)> 1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 06", IF(SUM(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 07", IF(SUM(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 08", IF(SUM(D3 : D6)> 1, "A-B-C-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-x-Y-Z 09", if (Sum (D3: D6)> 1, A-B-C-E-F-H-H-I-J-K-L-M-N-P--S------- (СУММ(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 12", ЕСЛИ(СУММ(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-V-M-N-O-P-Q-R-S-W-T-XU- Y-Z 13", IF(SUM(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 14","нет" ))))))))))))))))
Теперь, когда я вызываю следующую подпрограмму VBA
Private Sub Get_Formula()
MsgBox Selection.Formula
End Sub
то я получаю не полную формулу, а только
= If (sum (d3: d6)> 1, "A-b-c-d-e-f-g-j-j-k-l-m-n-p-q-r-s-t-u-й-x-z 01", if (sum (d3: d6)> 1, "A-b-c-e-g-h-j-k-n-m-n-p-p-d-r-s-й-й-z-----------------------------------------------ни--не-j--------- -V-W-X-Y-Z 03", IF(SUM(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 04", IF(SUM(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 05", IF(SUM(D3:D6)> 1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 06", IF(SUM(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 07", IF(SUM(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 08", IF(SUM(D3 : D6)> 1, "A-B-C-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-x-Y-Z 09", if (Sum (D3: D6)> 1, A-B-C-E-F-H-H-I-J-K-L-M-N-P--S------- (СУММ(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z 12", ЕСЛИ(СУММ(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-V-M-N-O-P-Q-R-S-W-T-XU- YZ 13", ЕСЛИ(СУММ(D3:D6)>1,"A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V
Как я могу получить полную формулу?