+ Reply to Thread
Results 1 to 27 of 27

VBA loop to multiply by negative one

Hybrid View

mkeys4 VBA loop to multiply by... 08-14-2013, 10:28 AM
mkeys4 Re: VBA loop to multiply by... 08-14-2013, 04:01 PM
hamjam Re: VBA loop to multiply by... 08-14-2013, 04:21 PM
mkeys4 Re: VBA loop to multiply by... 08-14-2013, 04:23 PM
hamjam Re: VBA loop to multiply by... 08-14-2013, 05:27 PM
mkeys4 Re: VBA loop to multiply by... 08-14-2013, 08:28 PM
hamjam Re: VBA loop to multiply by... 08-15-2013, 07:39 AM
hamjam Re: VBA loop to multiply by... 08-15-2013, 07:41 AM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 08:39 AM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 08:40 AM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 08:27 AM
hamjam Re: VBA loop to multiply by... 08-15-2013, 09:37 AM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 09:40 AM
hamjam Re: VBA loop to multiply by... 08-15-2013, 12:01 PM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 12:10 PM
hamjam Re: VBA loop to multiply by... 08-15-2013, 12:43 PM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 12:57 PM
hamjam Re: VBA loop to multiply by... 08-15-2013, 12:13 PM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 12:52 PM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 01:14 PM
hamjam Re: VBA loop to multiply by... 08-15-2013, 01:59 PM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 03:12 PM
mkeys4 Re: VBA loop to multiply by... 08-15-2013, 08:43 PM
HaHoBe Re: VBA loop to multiply by... 08-16-2013, 12:51 AM
mkeys4 Re: VBA loop to multiply by... 08-16-2013, 07:48 AM
mkeys4 Re: VBA loop to multiply by... 08-16-2013, 09:38 AM
HaHoBe Re: VBA loop to multiply by... 08-16-2013, 12:21 PM
  1. #1
    Forum Contributor
    Join Date
    07-15-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: VBA loop to multiply by negative one

    Awesome that did the trick!! I changed n=1 to 11 as well. Is that correct?

  2. #2
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: VBA loop to multiply by negative one

    Hello
    I manually named the ranges and got the code to work with these names (block1 and block2). You could go similar route especially considering that the ranges are changing so it would be pointless to hardcode cell references.

    Keep well
    Attached Files Attached Files
    Most helpful to mark solved items as such (see help for directions). Star ratings are always welcome.

  3. #3
    Forum Contributor
    Join Date
    07-15-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: VBA loop to multiply by negative one

    I tried to replace A12 with a positive number to see if the code would multiply L13:L17 by negative one, and it doesn't. Does it work for you?

+ 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. [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
  2. [SOLVED] VBA Loop to check range for Negative number
    By Zarley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2013, 01:58 PM
  3. If criteria match, multiply then sum across multiply worksheets
    By ciayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 02:20 PM
  4. Macro Loop until Negative number is reached and perform an interpolation
    By anaessens in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2012, 09:54 AM
  5. [SOLVED] Trying to execute function after negative if conditional nested in For each loop
    By Red in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 04:20 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