A simple loop

**kbka** · 12-12-2012, 01:09 PM

Hi,

I have written a little code that performs some formatting on the activecell.

Now, I would like for Excel to do this for every tenth cell in column C, starting at row 5.

So I would like my code to run in cell C5, then cell C15, then cel C25 etc. until cell C1585

How do I go about this in VBA?

regards,
kbka

**JieJenn** · 12-12-2012, 01:17 PM

you need to insert step statement.

So if you want to loop row 5 to 100 and skip every other 4 rows, it will looks like For i = 5 to 100 step 4 Next i

**AlphaFrog** · 12-12-2012, 01:21 PM

Please Login or Register  to view this content.

A simple loop

LinkBack

Thread Tools

Rate This Thread

Display

A simple loop

Re: A simple loop

Re: A simple loop

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions