Paste Range Loop

[2001jesper]

Hi i have the following code to copy rows based on a cell reference

However i cant seem to limit this range. i.e i need it to copy B:E if the row meets the pending criteria
How do i make my code relative with regards to this.

Furthermore, i get an error when pasting - cant seem to find the reason for this.

Than you in advance!!

Please Login or Register  to view this content.

[Debraj Roy]

Try this..

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[2001jesper]

Thx Patel it worked like a dream.. also thx to Debraj for the good pointers!!