how to increase value by 1 in vba

how can i increase the numerical value by 1?

'Increase QTD by 1
 .Sheets("Input").Range("B21").Value + 1

'Increase YTD by 1
 .Sheets("Input").Range("B22").Value + 1

Doesn't seem to like the +1.
Thanks.
jfrank85Asked:
Who is Participating?
 
Anthony BerenguelCommented:
Try
 .Sheets("Input").Range("B21").Value =.Sheets("Input").Range("B21").Value + 1
0
 
Anthony BerenguelCommented:
And

.Sheets("Input").Range("B22").Value =.Sheets("Input").Range("B22").Value + 1
0
 
jfrank85Author Commented:
worked perfect!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.