How to loop through cells in a range and then apply a formula to an offset to that range.

Hi All,

I am something of a VBA novice. I have written some code that selects (literally) every nth cell (n is a variable) in a long row range and then applies a formula to an offset to that cell. No doubt the experts here will realize that all this selecting slows the code down considerably. Can anyone show me how to use such a loop more efficiently. I thought about a combination of a For Next loop with step so that I would have something like:

Please Login or Register  to view this content.

I hope this makes some kind of sense.

TIA,

Andrew