Repeating a macro in every row

**phil2006** · 04-30-2009, 05:45 PM

Hi,

I have simply recorded the following code:

Please Login or Register  to view this content.

...however, I need the macro to work on every active row on sheet1 with the selected cells always moving down one row in each secton with the exception of the pasting on sheet3 which will always need to be in cell H5. When the macro reaches an inactive cell it should end. Any help here would be most appreciated.

Thanks in advance.

**JBeaucaire** · 04-30-2009, 06:23 PM

this would be way easier with a BEFORE/AFTER set of of worksheets to look at, so we know we are matching your intended results.

can you post a sample?

**JBeaucaire** · 04-30-2009, 06:28 PM

This macro will attempt to run your routine on all the rows that have data in column F starting at F5 and going down.

Please Login or Register  to view this content.

**broro183** · 04-30-2009, 08:40 PM

hi,

I agree with JB, that this would be much easier with an example workbook (these can be uploaded using the Paperclip or the Manage Attachment button). Also, I suspect there could be an easier/faster (depending on size of data set) way to achieve the same results without modifying two sheets "line by line".

Here is a slightly modified version of JB's code which will remove the risk* of accidental changing/clearing of the clipboard (eg pressing [ctrl + c], or [Esc]. *(if concurrently working in another application) - of course this isn't likely to be a problem if you just kick back or go & get a coffee while your macro is running.

Please Login or Register  to view this content.

hth
Rob

**phil2006** · 05-01-2009, 10:45 AM

Thank you all for your help. JB's code works just as I needed. You have literally saved me hours of work. Thank you very much.

**JBeaucaire** · 05-01-2009, 10:54 AM

My pleasure, that's what we hope for!

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED].

(Also, click on the "balance scales" icon across from the date on my post to leave Feedback, it is appreciated)