Posted to microsoft.public.excel.programming

Greg Snidow Greg Snidow is offline

external usenet poster

Posts: 153

Multiply a range by -1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiply range values with Lookup-value?	Jen[_13_]	Excel Programming	13	June 2nd 07 06:10 PM
How do I identify a number in a range and then multiply?	Leigh	Excel Programming	2	November 16th 06 05:24 AM
Multiply a range	Chris Mahoney	Excel Programming	4	February 24th 05 11:10 PM
Multiply a Range by a Constant	Jim Thomlinson[_3_]	Excel Programming	0	November 22nd 04 08:23 PM
Multiply range	Rodrigo[_2_]	Excel Programming	3	November 14th 03 01:18 PM

All times are GMT +1. The time now is 07:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us