VBA error 1004 object required
0
I am a new comer. I created a macro looking from many examples from the net. Getting runtime error 1004 object required. I also want to create a check to avoid duplication of sheets
Sub SACHINAddWorksheetsFromSelection()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Sheets("Master").Range("A2:A50")
sName = Trim(c.Text)
If Len(sName) > 0 Then
Sheets("Template").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = sName
End If
Next c
CurSheet.Activate
Application.ScreenUpdating = True
End Sub
runtime-error runtime
edited Jan 13 at 20:58
DavidPostill♦
106k26228263
asked Jan 13 at 20:05
Sachin GuptaSachin Gupta
1
add a comment |
0
I am a new comer. I created a macro looking from many examples from the net. Getting runtime error 1004 object required. I also want to create a check to avoid duplication of sheets
Sub SACHINAddWorksheetsFromSelection()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Sheets("Master").Range("A2:A50")
sName = Trim(c.Text)
If Len(sName) > 0 Then
Sheets("Template").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = sName
End If
Next c
CurSheet.Activate
Application.ScreenUpdating = True
End Sub
runtime-error runtime
edited Jan 13 at 20:58
DavidPostill♦
106k26228263
asked Jan 13 at 20:05
Sachin GuptaSachin Gupta
1
So which line is causing the error?
– DavidPostill♦
Jan 13 at 20:59
add a comment |
0
0
0
I am a new comer. I created a macro looking from many examples from the net. Getting runtime error 1004 object required. I also want to create a check to avoid duplication of sheets
Sub SACHINAddWorksheetsFromSelection()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Sheets("Master").Range("A2:A50")
sName = Trim(c.Text)
If Len(sName) > 0 Then
Sheets("Template").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = sName
End If
Next c
CurSheet.Activate
Application.ScreenUpdating = True
End Sub
runtime-error runtime
edited Jan 13 at 20:58
DavidPostill♦
106k26228263
asked Jan 13 at 20:05
Sachin GuptaSachin Gupta
1
I am a new comer. I created a macro looking from many examples from the net. Getting runtime error 1004 object required. I also want to create a check to avoid duplication of sheets
Sub SACHINAddWorksheetsFromSelection()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Sheets("Master").Range("A2:A50")
sName = Trim(c.Text)
If Len(sName) > 0 Then
Sheets("Template").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = sName
End If
Next c
CurSheet.Activate
Application.ScreenUpdating = True
End Sub
runtime-error runtime
runtime-error runtime
edited Jan 13 at 20:58
DavidPostill♦
106k26228263
asked Jan 13 at 20:05
Sachin GuptaSachin Gupta
1
edited Jan 13 at 20:58
DavidPostill♦
106k26228263
asked Jan 13 at 20:05
Sachin GuptaSachin Gupta
1
edited Jan 13 at 20:58
DavidPostill♦
106k26228263
edited Jan 13 at 20:58
DavidPostill♦
106k26228263
edited Jan 13 at 20:58
DavidPostill♦
106k26228263
106k26228263
asked Jan 13 at 20:05
Sachin GuptaSachin Gupta
1
asked Jan 13 at 20:05
Sachin GuptaSachin Gupta
1
asked Jan 13 at 20:05
Sachin GuptaSachin Gupta
1
1
So which line is causing the error?
– DavidPostill♦
Jan 13 at 20:59
add a comment |
So which line is causing the error?
– DavidPostill♦
Jan 13 at 20:59
So which line is causing the error?
– DavidPostill♦
Jan 13 at 20:59
So which line is causing the error?
– DavidPostill♦
Jan 13 at 20:59
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1393877%2fvba-error-1004-object-required%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1393877%2fvba-error-1004-object-required%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
So which line is causing the error?
– DavidPostill♦
Jan 13 at 20:59