Z
zealot
Hello Friends!!
I have a question about the macro that I am using to rotate throug
different values of 2 variables. The macro was created by a friend o
mine 2 years ago so I need some help to modify it. The macro is quit
usable so I hope someone will benefit from it. The problem is that i
doesn’t rotate through a range of integers but only from zero t
some number. In other words it allows to specify only the right hand o
the range through which it will rotate (for example, from 0 to 100 o
from 0 to 20 for A). The second issue with it is that it adds
difference number (“dif”, e.g. 3) to the start of th
second variable’s range and starts only from there (from 3 to 10
for B). The third issue is that it doesn’t allow to rotate throug
a third variable (“C”) as you will see in my example. I a
working on a task which requires precise definition of the range
through which the macro will rotate and also the ability to rotat
through a third variable. Do you think you can help me to modify it s
that all the three imperfections are removed from it? Or maybe ther
are ready made macros freely available which allow to do just that?
Thanks for you time!
+-------------------------------------------------------------------
|Filename: macros.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=87
+-------------------------------------------------------------------
I have a question about the macro that I am using to rotate throug
different values of 2 variables. The macro was created by a friend o
mine 2 years ago so I need some help to modify it. The macro is quit
usable so I hope someone will benefit from it. The problem is that i
doesn’t rotate through a range of integers but only from zero t
some number. In other words it allows to specify only the right hand o
the range through which it will rotate (for example, from 0 to 100 o
from 0 to 20 for A). The second issue with it is that it adds
difference number (“dif”, e.g. 3) to the start of th
second variable’s range and starts only from there (from 3 to 10
for B). The third issue is that it doesn’t allow to rotate throug
a third variable (“C”) as you will see in my example. I a
working on a task which requires precise definition of the range
through which the macro will rotate and also the ability to rotat
through a third variable. Do you think you can help me to modify it s
that all the three imperfections are removed from it? Or maybe ther
are ready made macros freely available which allow to do just that?
Thanks for you time!
+-------------------------------------------------------------------
|Filename: macros.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=87
+-------------------------------------------------------------------