Issues with CopyRows Macro on Checkboxes

[colinjwatson]

Hi,

I use a Search cell on my workbook, and when I do a search for a specific work it filters all the rows down to only return those words. I have checkboxes in column A to ensure that I can select them and add them to an order sheet.

Now when I do a search on something that only returns 1 row, and I click my check box and add to order sheet, it always returns Row 6 (which is the first row of my list) This only happens when its 1 row that is returned from the search.

I think its to do with the copyrows macro that I am using, but I can't figure out the issue. Is anyone able to assist at all on this?

Please Login or Register  to view this content.

Thanks in Advance

Colin

[TMS]

Suggest you post a sample workbook.

[colinjwatson]

Thanks TMS, I was going to strip out all the sensitive data and post one here but a guy in work managed to sort it.

For anyone reading this drop me a message if you use something similar and I will let you know