Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Darcy Jones   on Feb 22 In MS Office Category.

  
Question Answered By: Fred Hicks   on Feb 22

This code  seems fine. The + sign is no problem if the things you are
trying to add  or concatenate are all of the same type. In the code
below they're all strings. If they were all numbers and you didn't
have the space in there it would add the numbers together instead.

The & sign is the vba  string concatenator. If you had numbers in there
and used the &, the numbers would be treated as strings and
concatrenated.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on VBA code to add values in two cells which have formulas Or get search suggestion and latest updates.


Tagged: