I'm confused, so I'm going to be obnoxiously literal in order to get to the
bottom of the misunderstanding, like this: "Apparently you CAN use the
delete method, for you just told us that it does what you want. Did you mean
you MUST not use the delete method?".

And to add to that, I don't really understand what the difference is between
..Delete and .Clear. Is it just the warning message that's displayed to the
user with .Delete? Why exactly do you prefer the one to the other?

--- "kemp" wrote:
I need to save a sheet in csv-format. If I clear a range before saving, this
range appear in the csv-file as lines with comma separation. If I delete the
range, it does not appear in the csv-file at all. I want this, but I can not
use the delete method - how can it be done with a clear method ? can anybody
help or explain ?