Mixing
Updating Excel VBA reference
I have 2 sheets in a workbook Sheet1 and Sheet2.
Sheet1 Cell A1 contains ='Sheet2'!B2
Sheet2 Cell B2 contains 01/10/2018 and is formatted for dates
Sheet2 Cell B3 contains 01/11/2018 and is formatted for dates
Using VBA, I want to read the contents of Sheet1 Cell A1 and then update its contents to read the next date in the list ie.to become ='Sheet2'!B3
The problem I am having is that when I try to access Sheet1 Cell A1 it returns the value of the date in Sheet2 B2 rather than the contents of A1.
Any help would be greatly appreciated - thank you.
excel vba excel-vba
edited Nov 20 '18 at 7:19
Pᴇʜ
20.2k42650
asked Nov 19 '18 at 15:41
Ian E
1
add a comment |
I have 2 sheets in a workbook Sheet1 and Sheet2.
Sheet1 Cell A1 contains ='Sheet2'!B2
Sheet2 Cell B2 contains 01/10/2018 and is formatted for dates
Sheet2 Cell B3 contains 01/11/2018 and is formatted for dates
Using VBA, I want to read the contents of Sheet1 Cell A1 and then update its contents to read the next date in the list ie.to become ='Sheet2'!B3
The problem I am having is that when I try to access Sheet1 Cell A1 it returns the value of the date in Sheet2 B2 rather than the contents of A1.
Any help would be greatly appreciated - thank you.
excel vba excel-vba
edited Nov 20 '18 at 7:19
Pᴇʜ
20.2k42650
asked Nov 19 '18 at 15:41
Ian E
1
5
Read theFormulaproperty, not theValueproperty.
– Rory
Nov 19 '18 at 15:45
@Rory Thank you 👍
– Ian E
Nov 19 '18 at 15:59
add a comment |
I have 2 sheets in a workbook Sheet1 and Sheet2.
Sheet1 Cell A1 contains ='Sheet2'!B2
Sheet2 Cell B2 contains 01/10/2018 and is formatted for dates
Sheet2 Cell B3 contains 01/11/2018 and is formatted for dates
Using VBA, I want to read the contents of Sheet1 Cell A1 and then update its contents to read the next date in the list ie.to become ='Sheet2'!B3
The problem I am having is that when I try to access Sheet1 Cell A1 it returns the value of the date in Sheet2 B2 rather than the contents of A1.
Any help would be greatly appreciated - thank you.
excel vba excel-vba
edited Nov 20 '18 at 7:19
Pᴇʜ
20.2k42650
asked Nov 19 '18 at 15:41
Ian E
1
I have 2 sheets in a workbook Sheet1 and Sheet2.
Sheet1 Cell A1 contains ='Sheet2'!B2
Sheet2 Cell B2 contains 01/10/2018 and is formatted for dates
Sheet2 Cell B3 contains 01/11/2018 and is formatted for dates
Using VBA, I want to read the contents of Sheet1 Cell A1 and then update its contents to read the next date in the list ie.to become ='Sheet2'!B3
The problem I am having is that when I try to access Sheet1 Cell A1 it returns the value of the date in Sheet2 B2 rather than the contents of A1.
Any help would be greatly appreciated - thank you.
excel vba excel-vba
excel vba excel-vba
edited Nov 20 '18 at 7:19
Pᴇʜ
20.2k42650
asked Nov 19 '18 at 15:41
Ian E
1
edited Nov 20 '18 at 7:19
Pᴇʜ
20.2k42650
asked Nov 19 '18 at 15:41
Ian E
1
edited Nov 20 '18 at 7:19
Pᴇʜ
20.2k42650
edited Nov 20 '18 at 7:19
Pᴇʜ
20.2k42650
edited Nov 20 '18 at 7:19
Pᴇʜ
20.2k42650
20.2k42650
asked Nov 19 '18 at 15:41
Ian E
1
asked Nov 19 '18 at 15:41
Ian E
1
asked Nov 19 '18 at 15:41
Ian E
1
1
5
Read theFormulaproperty, not theValueproperty.
– Rory
Nov 19 '18 at 15:45
@Rory Thank you 👍
– Ian E
Nov 19 '18 at 15:59
add a comment |
5
Read theFormulaproperty, not theValueproperty.
– Rory
Nov 19 '18 at 15:45
@Rory Thank you 👍
– Ian E
Nov 19 '18 at 15:59
5
5
Read the
Formula property, not the Value property.– Rory
Nov 19 '18 at 15:45
Read the
Formula property, not the Value property.– Rory
Nov 19 '18 at 15:45
@Rory Thank you 👍
– Ian E
Nov 19 '18 at 15:59
@Rory Thank you 👍
– Ian E
Nov 19 '18 at 15:59
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
});
}
});
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%2f53378089%2fupdating-excel-vba-reference%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
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
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%2f53378089%2fupdating-excel-vba-reference%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
5
Read the
Formulaproperty, not theValueproperty.– Rory
Nov 19 '18 at 15:45
@Rory Thank you 👍
– Ian E
Nov 19 '18 at 15:59