I'm new to VBA, trying to learn as quickly as I can. I am trying to do what I think is a simple task, but it's not working. I simply want to select a group of cells, then change the sign (multiply by -1). I'm not sure why. Could someone help?
Sub Changesign(ByVal numsToChange As Range)
Dim checkRange As Range
For Each checkRange In numsToChange
checkRange = checkRange * -1