VBA: Purpose of .Text and .Formula (when writing)?
up vote
0
down vote
favorite
I'm pretty new to VBA and I was wondering if there's a point to distinguish between Range().Value and Range().Formula/Text when writing data to cells. I've tried it and it seems to me that it works just as well using .Value.
I know that they return different things when used to read out data
vba excel-vba
New contributor
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
favorite
I'm pretty new to VBA and I was wondering if there's a point to distinguish between Range().Value and Range().Formula/Text when writing data to cells. I've tried it and it seems to me that it works just as well using .Value.
I know that they return different things when used to read out data
vba excel-vba
New contributor
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
You can highlight a word in the VBE, and press F1 and it will display a lot of information for you.range.Text
andrange.Formula
– K.Dᴀᴠɪs
18 hours ago
@K.Dᴀᴠɪs-I did not know that, I feel very informed right now.
– Davesexcel
18 hours ago
Possible duplicate of What is the difference between .text, .value, and .value2?
– Vasily
16 hours ago
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm pretty new to VBA and I was wondering if there's a point to distinguish between Range().Value and Range().Formula/Text when writing data to cells. I've tried it and it seems to me that it works just as well using .Value.
I know that they return different things when used to read out data
vba excel-vba
New contributor
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm pretty new to VBA and I was wondering if there's a point to distinguish between Range().Value and Range().Formula/Text when writing data to cells. I've tried it and it seems to me that it works just as well using .Value.
I know that they return different things when used to read out data
vba excel-vba
vba excel-vba
New contributor
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 19 hours ago
Alex
235
235
New contributor
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
You can highlight a word in the VBE, and press F1 and it will display a lot of information for you.range.Text
andrange.Formula
– K.Dᴀᴠɪs
18 hours ago
@K.Dᴀᴠɪs-I did not know that, I feel very informed right now.
– Davesexcel
18 hours ago
Possible duplicate of What is the difference between .text, .value, and .value2?
– Vasily
16 hours ago
add a comment |
You can highlight a word in the VBE, and press F1 and it will display a lot of information for you.range.Text
andrange.Formula
– K.Dᴀᴠɪs
18 hours ago
@K.Dᴀᴠɪs-I did not know that, I feel very informed right now.
– Davesexcel
18 hours ago
Possible duplicate of What is the difference between .text, .value, and .value2?
– Vasily
16 hours ago
You can highlight a word in the VBE, and press F1 and it will display a lot of information for you.
range.Text
and range.Formula
– K.Dᴀᴠɪs
18 hours ago
You can highlight a word in the VBE, and press F1 and it will display a lot of information for you.
range.Text
and range.Formula
– K.Dᴀᴠɪs
18 hours ago
@K.Dᴀᴠɪs-I did not know that, I feel very informed right now.
– Davesexcel
18 hours ago
@K.Dᴀᴠɪs-I did not know that, I feel very informed right now.
– Davesexcel
18 hours ago
Possible duplicate of What is the difference between .text, .value, and .value2?
– Vasily
16 hours ago
Possible duplicate of What is the difference between .text, .value, and .value2?
– Vasily
16 hours ago
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Alex is a new contributor. Be nice, and check out our Code of Conduct.
Alex is a new contributor. Be nice, and check out our Code of Conduct.
Alex is a new contributor. Be nice, and check out our Code of Conduct.
Alex is a new contributor. Be nice, and check out our Code of Conduct.
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
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53237155%2fvba-purpose-of-text-and-formula-when-writing%23new-answer', 'question_page');
);
Post as a guest
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
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
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
You can highlight a word in the VBE, and press F1 and it will display a lot of information for you.
range.Text
andrange.Formula
– K.Dᴀᴠɪs
18 hours ago
@K.Dᴀᴠɪs-I did not know that, I feel very informed right now.
– Davesexcel
18 hours ago
Possible duplicate of What is the difference between .text, .value, and .value2?
– Vasily
16 hours ago