Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel:referring to formulas of cells

Status
Not open for further replies.
gusset

gusset

Technical User
Mar 19, 2002
251
GB
why are there two properties: .formula and .value of cell ranges? i find that i can say either...

.value = "=sum(A1:A3)"
or
.formula = "=sum(A1:A3)"

...and the result is the same

thanks

gusset
 
Sort by date Sort by votes
Try it the other way 'round...
Code: 
   MsgBox Range("A4").Value 
     vs.
   MsgBox Range("A4").Formula
...and you should see the difference.
 
Upvote 0 Downvote
what a silly oaf i am. of course, that's why!

thanks

gusset
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TenDollarTypo
  • Locked
  • Question
Merge every 9 Cells Loop
Replies
3
Views
405
TenDollarTypo
TenDollarTypo
Katto
  • Locked
  • Question
VBA permutation of arrays
2
Replies
22
Views
1K
Katto
Katto
K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
842
combo
combo
rf92d
  • Locked
  • Question
Hi referring to thread707-107529
Replies
0
Views
585
rf92d
rf92d
rf92d
  • Locked
  • Question
hi referring to thread707-103495
Replies
9
Views
845
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top