macro creating a spreadsheet

[Rick]

I have a macro on a spreadsheet that creates another
spreadsheet. There are conditions that have to be met
for the last 3 columns to receive data. The problem is
that when this condition is not met, these columns end
after 16 rows. While this is not a problem for the
spreadsheet, I do import the spreadsheet into another
application where the short columns do cause problems

If this makes any sense or I need to explain further
please let me know.

Thank you,

Rick

 

[Frank Kabel]

Hi
not really sure what your issue is. Provide some example data and maybe
even the relevant part of your code

 

[N10]

Hi Rick

Your post is not that clear really but let me ask you the following ;


So is it that you need to test (in code) whether or not the last three
columns contain data ?

Then if the last three columns do not contain data proceed to prevent
update of the second spreadsheet ?

Best N10