Hi,
Firstly, thank you for the time & trouble that you go to in producing the excellent, easy to follow, Excel Videos.
My question is:- in a Macro where you want to use a "Do While Loop" (or some other type of Loop), can you use the number in a Cell from another Sheet in the same Workbook to determine how many Loops the Macro performs.
For instance, if on Sheet 1 I have a Drop Down Menu of the 26 letters of the alphabet, and I choose the 6th. letter down (F), and this puts the number '6' in Cell A1 of Sheet 1, can I use this '6' or 'Sheet1, Cell A1', in the Loop function statement in a Macro, used on Sheet 2 of the Workbook, to Loop 6 times? The Sheet 2 Macro would be triggered by a Command Button on Sheet2 to perform certain tasks, in this example, 6 times.
Obviously, if the above is possible, which ever number between 1 and 26 is chosen, that will determine how many Loops are performed.
I hope that's clear, and if it is possible, then I'd much appreciate a piece of Code.
Many thanks, Freddie (in England).