macro to export range of cell not working

[mazan2010]

Dear sir
please kindly find my attached file with export button that not working for exprt range of cell have value from A1:G7

[LeoTaxi]

something wrong with your autofilter criteria
with good criteria, or without autofilter it works

Kind regards
Leo

[bakerman2]

You're autofilter is causing the problem.
What value is supposed to be filtered ?

[mazan2010]

when column A is empty not fill any column related to this cell
meaning if A2 is empty leave B2:G2 is empty

[mazan2010]

how can solve it

[mazan2010]

filtration is to export only cell have value
for example if row 3 is empty and 2,4,5 have value its export 2,4,5 row without any space empty row
hope you understand me now

[mazan2010]

also want only export data in range of A1:G7

[bakerman2]

Your autofilter like this

Please Login or Register  to view this content.

solves your problem.

[mazan2010]

what about change range to become A1:G7

Your autofilter like this

Please Login or Register  to view this content.

solves your problem.

[bakerman2]

I hope this is what you mean otherwise I don't understand the question.

Please Login or Register  to view this content.

[mazan2010]

Dear Bakerman its work good now many thanks for your help and solution

[bakerman2]

You're welcome and thanks for rep+.