VBA~無法顯示效果檔的語法修正。:Realtime－台北中山區韓之棧韓國料理2016在台北吃到好吃的首爾傳統韓國料理[美食]台北東區‧明洞館(韓國料理涓豆腐

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決

VBA~無法顯示效果檔的語法修正。

Jan 19th 2015, 00:28

問題︰應有的效果檔無法正確產生。
需求︰請問下列的程式碼應該如何修正?謝謝!

'AG公式....................................
.Calculate

For Each a In.Range("AG7", "AG" & .[R65536].End(xlUp).Row)

If a = "" Then

a.Value = ""

Else

a.Value = a.Value '1_顯示公式運算後純值

Mysheet = 1

End If

If Mysheet = 0 Then

.Delete '4_移除

Else

Sharr(s) = 1

If ActiveWorkbook.Sheets(arr(s- 1)).Tab.ColorIndex = 6 Then Shbrr(s) = s

End If

Recommended article: Chomsky: We Are All – Fill in the Blank.
This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions