|
|
|
Убрать черточки в формуле ваще 6L1N
|
|||
|---|---|---|---|
|
#18+
Делаю так вот For j = nom_pr To i fid1 = Me.Spreadsheet1.Worksheets(2).Cells(j, 2).value If fid1 <> "" Then If Me.Spreadsheet1.Worksheets(1).Cells(i, 14).Formula = "" Then Me.Spreadsheet1.Worksheets(1).Cells(i, 14).Formula = "=" Else Me.Spreadsheet1.Worksheets(1).Cells(i, 14).Formula = Trim(Me.Spreadsheet1.Worksheets(1).Cells(i, 14).Formula & "+" & "R[-" & CStr(i - fid1) & "]C") End If Debug.Print fid1, nom_pr, j, i, Me.Spreadsheet1.Worksheets(1).Cells(i, 14).Formula End If Выдает так вот подскажите как убрать Черточки эти может я что не дописал =+_N5+_N10+_N17+N25 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.05.2009, 23:37 |
|
||
|
|

start [/forum/search_topic.php?author=yulka80%40mail.ru&author_mode=last_posts&do_search=1]: |
0ms |
get settings: |
6ms |
get forum list: |
15ms |
get settings: |
8ms |
get forum list: |
11ms |
get settings: |
8ms |
get forum list: |
12ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
25ms |
get topic data: |
10ms |
get first new msg: |
6ms |
get forum data: |
3ms |
get page messages: |
32ms |
get tp. blocked users: |
1ms |
| others: | 639ms |
| total: | 782ms |

| 0 / 0 |
