If Statment loop

**Rachel5694** · 07-16-2018, 09:08 AM

I am trying to loop this If statement so it goes down all the rows and reads them. Like right now it is reading Q2 & R2. I want to loop it so next it will look at Q3 &R3 then output range (A3:AN3) and then with row 4, etc.

Please Login or Register  to view this content.

**Kaper** · 07-16-2018, 09:41 AM

Try:

Please Login or Register  to view this content.

or if you want all columnbs upto AN colored, then

Please Login or Register  to view this content.

**YasserKhalil** · 07-16-2018, 09:42 AM

Try this code

Please Login or Register  to view this content.

**Rachel5694** · 07-17-2018, 09:17 AM

It worked thank you so much!

**YasserKhalil** · 07-20-2018, 08:20 AM

You're welcome. Glad we can offer some help
Thanks a lot for the rep points

If Statment loop

LinkBack

Thread Tools

Rate This Thread

Display

If Statment loop

Re: If Statment loop

Re: If Statment loop

Re: If Statment loop

Re: If Statment loop

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] for and next loop with if statment

[SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)

[SOLVED] IF Statment - Carry common part of IF Statment for entire column

[SOLVED] if then statment help

IF Statment Loop in VB

[SOLVED] IF statment within IF statment?

End a DO WHILE LOOP WITH INTERNAL IF STATMENT?

IF Statment

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions