Counters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

halem2 - 30 Jun 2006 21:37 GMT

Hi folks:

I have some code I need to run let's say 10 times on the same sheet.
How can I use counters s I don't have to retype the code 10 times?

Also, how can I go to the following sheet to the right after the cod
executes the 10th time on that sheet?

thanks:confused

Reply to this Message

halem2 - 30 Jun 2006 21:44 GMT

ok I figured out the Counter

for i = 1 to 10
code here
next i

Now how can I go to the next work sheet, assuming I have 150
worksheets?

thanks

Signature

halem2

Reply to this Message

Thyagaraj - 30 Jun 2006 21:50 GMT

> Hi folks:
>
[quoted text clipped - 11 lines]
> halem2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9930
> View this thread: http://www.excelforum.com/showthread.php?threadid=557473

Dear Halem2,

You can use the following code :-

Sub Repeat1()
Dim N
N = 1
Do Until N = 10
'enter the code which needs to be repeated
N = N + 1
Loop
'Next sheet Selection
ActiveSheet.Next.Select
End Sub

Regards
Thyagaraj Shetty C.N
Bangalore

Reply to this Message

halem2 - 30 Jun 2006 21:59 GMT

thanks!!! I just got it working using

For Each SH In ActiveWorkbook.Worksheets
SH.Activate
my code
Next

thanks a lot;) :cool:

Signature

halem2

Reply to this Message