LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 9
Default Rotating through a range of integers

Hello Friends!!

I have a question about the macro that I am using to rotate through different values of 2 variables. The macro was created by a friend of mine 2 years ago so I need some help to modify it. The macro is quite usable so I hope someone will benefit from it. The problem is that it doesn’t rotate through a range of integers but only from zero to some number. In other words it allows to specify only the right hand of the range through which it will rotate (for example, from 0 to 100 or from 0 to 20 for A). The second issue with it is that it adds a difference number (“dif”, e.g. 3) to the start of the second variable’s range and starts only from there (from 3 to 100 for B). The third issue is that it doesn’t allow to rotate through a third variable (“C”) as you will see in my example. I am working on a task which requires precise definition of the ranges through which the macro will rotate and also the ability to rotate through a third variable. Do you think you can help me to modify it so that all the three imperfections are removed from it? Or maybe there are ready made macros freely available which allow to do just that?

Thanks for you time!

D
Attached Files
File Type: zip macros.zip (20.9 KB, 89 views)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
self-sizing adv.filter criteria range BorisS Excel Discussion (Misc queries) 3 September 24th 06 01:30 PM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
Wrap Text Across Columns & Rows Michael Excel Dude Excel Discussion (Misc queries) 1 September 4th 06 02:14 AM
Duplicate Range Names by worksheet FlaAl Excel Discussion (Misc queries) 0 May 24th 06 05:14 PM
Help with using range names in sum function soteman2005 Excel Worksheet Functions 2 November 28th 05 04:43 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"