Awesome that did the trick!! I changed n=1 to 11 as well. Is that correct?
Awesome that did the trick!! I changed n=1 to 11 as well. Is that correct?
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
Most helpful to mark solved items as such (see help for directions). Star ratings are always welcome.
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks