A Macro that Copied Rows Which Met a Specific Criteria Worked and Now Errors

[acer1234]

A macro that copied rows which met a specific criteria from a sheet called "Main" to another sheet called "FDL" has worked for days and is now giving an error message and I am not sure why.

Here is the code:

Please Login or Register  to view this content.

Can any of you identify any errors?

Thanks.

[TMS]

Well, you'd need to tell us what error message and which line is highlighted.

But, in reality, if the code has worked and nothing has changed in the code, the chances are that its OK.

That means it's more likely to be the data that it's processing. Are there any text values where there should be numerical values? Have you changed the structure of the workbook or worksheets? Added rows or columns? Changed headings? Whatever.

It would probably be useful to post a sample workbook.

Regards, TMS

[john456852]

I gotta see the values in cells

[john456852]

check where you r supposed to type values