We help IT Professionals succeed at work.

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.
Comment
Watch Question

Try
 .Sheets("Input").Range("B21").Value =.Sheets("Input").Range("B21").Value + 1
And

.Sheets("Input").Range("B22").Value =.Sheets("Input").Range("B22").Value + 1

Author

Commented:
worked perfect!