以下為我錄製巨集,程式碼,出現執行階段錯誤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