Based on its value...copy D:X... what value are your testing for? Anything?

Without referring to your code, can you just explain verbally what you're macro is supposed to accomplish?

For instance:
"For every cell in B2:B200 that is not blank, copy D:X to another sheet. On the new sheet I want all the data without blanks"

If you post up your sheet with perhaps an example BEFORE/AFTER, we can help more specifically.