I would actually be really interested in finding an answer on this one too.
For most things I use the For function but I find myself repeating lines over again. Eg I have txtboxes for each month and the contents are either user defined or looked up from a sheet. But now I want to get the contents back to a different sheet. Instead of repeating multiple lines of code, I'd prefer to use a For Each "txtbox". They've all got essentially the same name...F1, F2, F3 etc.
Is there anything I can do to make it simpler...and cut down my code by half