Running Macro on same row in two worksheets

[dale040205]

I know this has been asked many times on many different forums, which is where I got the code I'm using, but I just can't seem to get it to work correctly. My workbook has five worksheets, and my code is supposed to insert a blank row at the same spot on two of them, copying the formulae from the row above. However, all it ends up doing is inserting five blank rows with the formulae in the worksheet the user is viewing. Now, I did combine two codes from two different places, so I'm sure the problem is I didn't combine them properly (one for inserting the blank row, the other for doing it across multiple worksheets). The two worksheets I want this code to run on are labeled "Register" and "Budget". Here's my code:

Please Login or Register  to view this content.

Thanks for the help!

[HaHoBe]

Hi, dale040205,

although you loop through all sheets the code will always be performed on the active sheet due to the fact that there is no indication for VBA to apply it to different worksheets.

Maybe give this code a try:

Please Login or Register  to view this content.

And please use Code-Tags to display the code as requested per Forum-Rules.

Ciao,
Holger

[dale040205]

That worked great, thank you. Added code tags to original post!