Array Copying Help

Macro sets end range for copying by determine lastrow i.e.

Please Login or Register  to view this content.

Then macro copies range from row 3 to lastrow as you wish to avoid copy headings

Please Login or Register  to view this content.

but if the is no data in row 3 and the rows below the lastrow will be 2 assuming headings in row 1 and 2 and macro will copy row 2 and 3 in the specified column. Row 2 will contain heading and row 3 is empty so this what gets copied.

Alf

You need to test if lastrow is less than 3 and skip the copy operation in this case

Alf,

That makes perfect sense! It's been running me ragged . I shall write up a test for last row.

Thanks

You are welcome.

Thanks for feedback and rep

Alf