Airman
Lv 4
Airman asked in 電腦與網際網路軟體 · 8 years ago

VBA~如何消除【#VALUE!】為空白的語法?

參考範例︰http://www.FunP.Net/396546

如果不執行Module1的自訂函數,則都沒問題;

但如果有執行Module1的自訂函數,就會產生下列小問題~

效果檔案在某些工作表的T欄會顯示#VALUE!,

且大部分都出現在第一個有顯示計算值之前應為空白的儲存格。

請詳見︰FT_ 49F RL_Example

請問︰想要消除儲存格的#VALUE!,應該如何修正相關的程式碼? 謝謝!

2 Answers

Rating
  • 顯栓
    Lv 7
    8 years ago
    Favorite Answer

    列 43

    If ST_ROW.Offset(I) = "" Then Exit Do

    移到

    列28

    Do

    列28 If ST_ROW.Offset(I) = "" Then Exit Do

        For J = 2 To 8

         If Cells(ST_ROW.Offset(I) + 7 + a, J) = V Then

    2011-11-22 11:09:17 補充:

    列 43

    If ST_ROW.Offset(I) = "" Then Exit Do

    移到

    列28

    Do

    列28 If ST_ROW.Offset(I) = "" Then Exit Do

        For J = 2 To 8

         If Cells(ST_ROW.Offset(I) + 7 + a, J) = V Then

    • Login to reply the answers
  • Airman
    Lv 4
    8 years ago

    applerot知識長︰您好!

    呵~呵~您太厲害了!沒有被小弟不正確(儲存格不應該是空白)的題意說明誤導。

    貴解完全符合需求,敬請移駕回答區。謝謝您!

    ^_^

    • Login to reply the answers
Still have questions? Get your answers by asking now.