Export limited column range to csv and only export cells with a value

[MagicMan]

Hi Team,

I have an spreadsheet that I use to export to csv ready for uploading to a different system.

The code I have works well. However, it exports everything. I'd like to achieve two things:

1. Only export the data up to columns 16 (Col P)
   • Ignoring columns Q and R
2. Only export the rows where there is a value (and not a formula)
   • The number of rows is variable

In the attached example. Currently activating the macro would export Columns A - R and Rows 1 - 20 to a CSV. However, I would like it to export Columns A - P and Rows 1 - 5.

I would like to retain the ability to retain the ability to determine the filename and folder.

Can anyone help?

Thanking you in anticipation

[harprik]

Hi,

does this work for you?ZZZ Test.xlsm

[MagicMan]

Ab-so-lutel-ly bleedin' perfect harprik.

Thank you so much and Rep added

MM