Why not just loop through the cells...

Dim C As Range
......
......
For Each C In Range("E" & LastRow - 3 & ":I" & LastRow - 3)
C.Value = -C.Value
Next

--
Rick (MVP - Excel)


"Greg Snidow" wrote in message
...
Greetings everyone. I need to take all the values in a range, and make
them
negative. I tried....

Range("E" & LastRow - 3 & ":I" & LastRow - 3) = _
Range("E" & LastRow - 3 & ":I" & LastRow - 3) * -1

I know I can put a -1 in a cell, then copy and paste special - multiply,
but
I was looking for something the user will not see. Any ideas? Thank you.

Greg