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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Rick" schrieb im Newsbeitrag
...
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

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

"Rick" wrote in message
...
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