close
Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
excel錄製巨集問題
Jul 29th 2013, 13:37

以下為我錄製巨集,程式碼,出現執行階段錯誤1004

錯誤出現在下列程式碼,請較大大,下列指的-14,-5是什麼意思?

ActiveCell.Offset(-14, -5).Range("A1").Select

------------------------------------------------------------------------
Sub Macro6()
'
' Macro6 Macro
'
' 快速鍵: Ctrl+e
'
Selection.Copy
Sheets("1").Select
ActiveCell.Offset(-14, -5).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Selection.QueryTable.Refresh BackgroundQuery:=False
ActiveCell.Offset(0, 1).Range("A1:E1").Select
Selection.Copy
Sheets("選股總表").Select
ActiveCell.Offset(0, 1).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(1, -1).Range("A1").Select
End Sub

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. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html

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
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 nbv14tiaw18li 的頭像
    nbv14tiaw18li

    進擊的巨人14, 進擊的巨人線上看, 進擊的巨人漫畫, 進擊的巨人遊戲, 進擊的巨人 動畫, 進擊的巨人 線上漫畫, 進擊的巨人14線上看, 進擊的巨人13, 進擊的巨人 h, 進擊的巨人op

    nbv14tiaw18li 發表在 痞客邦 留言(0) 人氣()