Errors in VBA 2016
0
The below part of my VBA code works perfectly in Excel 2010 but shuts down Excel 2016 without even sending an error message. Please advise
Range("Z2:Z" & LastRow).Select
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""NEW EMPLOYEE"""
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 13408767
.TintAndShade = 0
End With
excel vba excel-vba
edited Nov 21 '18 at 14:52
Pᴇʜ
24k63052
asked Nov 21 '18 at 14:47
TelpekTelpek
133
add a comment |
0
The below part of my VBA code works perfectly in Excel 2010 but shuts down Excel 2016 without even sending an error message. Please advise
Range("Z2:Z" & LastRow).Select
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""NEW EMPLOYEE"""
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 13408767
.TintAndShade = 0
End With
excel vba excel-vba
edited Nov 21 '18 at 14:52
Pᴇʜ
24k63052
asked Nov 21 '18 at 14:47
TelpekTelpek
133
3
First I recommend to read and apply How to avoid using Select in Excel VBA. • Excel shutting down without message means it crashes. That is not a VBA error, that means it is a bug in Excel. Restart computer, update Windows, update Excel to the most current build version. If this doesn't help ask the Microsoft support.
– Pᴇʜ
Nov 21 '18 at 14:52
Use the debugger to step through your code and find out exactly which of the above lines causes the error and add that info to your question
– Dan
Nov 21 '18 at 14:53
1
WhyFormula1:="=""NEW EMPLOYEE"""instead of just using a string value?
– Comintern
Nov 21 '18 at 15:03
6
You can always record it again in 2016, and see the difference.
– usmanhaq
Nov 21 '18 at 15:04
add a comment |
0
0
0
The below part of my VBA code works perfectly in Excel 2010 but shuts down Excel 2016 without even sending an error message. Please advise
Range("Z2:Z" & LastRow).Select
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""NEW EMPLOYEE"""
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 13408767
.TintAndShade = 0
End With
excel vba excel-vba
edited Nov 21 '18 at 14:52
Pᴇʜ
24k63052
asked Nov 21 '18 at 14:47
TelpekTelpek
133
The below part of my VBA code works perfectly in Excel 2010 but shuts down Excel 2016 without even sending an error message. Please advise
Range("Z2:Z" & LastRow).Select
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""NEW EMPLOYEE"""
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 13408767
.TintAndShade = 0
End With
excel vba excel-vba
excel vba excel-vba
edited Nov 21 '18 at 14:52
Pᴇʜ
24k63052
asked Nov 21 '18 at 14:47
TelpekTelpek
133
edited Nov 21 '18 at 14:52
Pᴇʜ
24k63052
asked Nov 21 '18 at 14:47
TelpekTelpek
133
edited Nov 21 '18 at 14:52
Pᴇʜ
24k63052
edited Nov 21 '18 at 14:52
Pᴇʜ
24k63052
edited Nov 21 '18 at 14:52
Pᴇʜ
24k63052
24k63052
asked Nov 21 '18 at 14:47
TelpekTelpek
133
asked Nov 21 '18 at 14:47
TelpekTelpek
133
asked Nov 21 '18 at 14:47
TelpekTelpek
133
133
3
First I recommend to read and apply How to avoid using Select in Excel VBA. • Excel shutting down without message means it crashes. That is not a VBA error, that means it is a bug in Excel. Restart computer, update Windows, update Excel to the most current build version. If this doesn't help ask the Microsoft support.
– Pᴇʜ
Nov 21 '18 at 14:52
Use the debugger to step through your code and find out exactly which of the above lines causes the error and add that info to your question
– Dan
Nov 21 '18 at 14:53
1
WhyFormula1:="=""NEW EMPLOYEE"""instead of just using a string value?
– Comintern
Nov 21 '18 at 15:03
6
You can always record it again in 2016, and see the difference.
– usmanhaq
Nov 21 '18 at 15:04
add a comment |
3
First I recommend to read and apply How to avoid using Select in Excel VBA. • Excel shutting down without message means it crashes. That is not a VBA error, that means it is a bug in Excel. Restart computer, update Windows, update Excel to the most current build version. If this doesn't help ask the Microsoft support.
– Pᴇʜ
Nov 21 '18 at 14:52
Use the debugger to step through your code and find out exactly which of the above lines causes the error and add that info to your question
– Dan
Nov 21 '18 at 14:53
1
WhyFormula1:="=""NEW EMPLOYEE"""instead of just using a string value?
– Comintern
Nov 21 '18 at 15:03
6
You can always record it again in 2016, and see the difference.
– usmanhaq
Nov 21 '18 at 15:04
3
3
First I recommend to read and apply How to avoid using Select in Excel VBA. • Excel shutting down without message means it crashes. That is not a VBA error, that means it is a bug in Excel. Restart computer, update Windows, update Excel to the most current build version. If this doesn't help ask the Microsoft support.
– Pᴇʜ
Nov 21 '18 at 14:52
First I recommend to read and apply How to avoid using Select in Excel VBA. • Excel shutting down without message means it crashes. That is not a VBA error, that means it is a bug in Excel. Restart computer, update Windows, update Excel to the most current build version. If this doesn't help ask the Microsoft support.
– Pᴇʜ
Nov 21 '18 at 14:52
Use the debugger to step through your code and find out exactly which of the above lines causes the error and add that info to your question
– Dan
Nov 21 '18 at 14:53
Use the debugger to step through your code and find out exactly which of the above lines causes the error and add that info to your question
– Dan
Nov 21 '18 at 14:53
1
1
Why
Formula1:="=""NEW EMPLOYEE""" instead of just using a string value?– Comintern
Nov 21 '18 at 15:03
Why
Formula1:="=""NEW EMPLOYEE""" instead of just using a string value?– Comintern
Nov 21 '18 at 15:03
6
6
You can always record it again in 2016, and see the difference.
– usmanhaq
Nov 21 '18 at 15:04
You can always record it again in 2016, and see the difference.
– usmanhaq
Nov 21 '18 at 15:04
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53414615%2ferrors-in-vba-2016%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 Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53414615%2ferrors-in-vba-2016%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
3
First I recommend to read and apply How to avoid using Select in Excel VBA. • Excel shutting down without message means it crashes. That is not a VBA error, that means it is a bug in Excel. Restart computer, update Windows, update Excel to the most current build version. If this doesn't help ask the Microsoft support.
– Pᴇʜ
Nov 21 '18 at 14:52
Use the debugger to step through your code and find out exactly which of the above lines causes the error and add that info to your question
– Dan
Nov 21 '18 at 14:53
1
Why
Formula1:="=""NEW EMPLOYEE"""instead of just using a string value?– Comintern
Nov 21 '18 at 15:03
6
You can always record it again in 2016, and see the difference.
– usmanhaq
Nov 21 '18 at 15:04