I need to create an excel macro that adds a 32 to the beginning of each number in a range of cells. I have a range of >1500 cells. So far I have used the following macro, but it only does one cell at a time:
Sub AddToCell()
'ActiveCell.Value places the value or formula into the active cell
'on the active worksheet.
'
'ActiveCell.Value returns the value in the active cell of the active
'window.
'
'InputBox calls up the Excel input box for you to type in the number
'to be added to the original value. Val takes the text string
'returned from the input box and turns it into a number.
ActiveCell.Value = ActiveCell.Value + _
Val(InputBox("3100", default:=1))
End Sub
Any help would be appreciated!
