+ Reply to Thread
Results 1 to 4 of 4

Multiply Range by negative 1

  1. #1
    Forum Contributor
    Join Date
    10-05-2012
    Location
    Washington
    MS-Off Ver
    Excel 2013
    Posts
    106

    Multiply Range by negative 1

    I have a macro that I use for data entry. Currently, when something that has been shipped is tracked the macro goes through several lines of code to change the new shipment to negative numbers.

    Is there a way to something like

    Please Login or Register  to view this content.
    I know just adding the * -1 doesn’t work but the rest of it does successfully reference the range I need to multiply by -1.
    Any insight would be greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Multiply Range by negative 1

    This code is from recorded macro, assuming that the value of -1 is in C1 and want to multiply to column A.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Multiply Range by negative 1

    Cut the rubbish.

    Please Login or Register  to view this content.
    Last edited by AB33; 11-07-2013 at 03:55 AM.

  4. #4
    Forum Contributor
    Join Date
    10-05-2012
    Location
    Washington
    MS-Off Ver
    Excel 2013
    Posts
    106

    Re: Multiply Range by negative 1

    Thats what I do now. I was just trying to see if it was possible to reduce the steps needed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA loop to multiply by negative one
    By mkeys4 in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 08-16-2013, 12:21 PM
  2. [SOLVED] If cell is negative multiply by -1 formula
    By thelegazy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2013, 11:36 AM
  3. Replies: 1
    Last Post: 11-20-2008, 01:52 AM
  4. vba-multiply a range with number(text_box) and format range
    By pinstripe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2007, 06:14 AM
  5. [SOLVED] Multiply a range
    By Chris Mahoney in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1