clearing cells without removing data validation

[asylum]

HI all,

I have some simple code which opens a wookbook, and pastes in data, then saves and closes it no problems.

I also have some code which opens the same workbook, selects all the data present and clears the cells (either by clear function or delete). However, either way I do this it also removes the data vaidation i have set on some of the columns.

Is there a function i can use which will allow me to remove the data, then close & save the workbook without destroying the data vaildation which i need ready for the next set of data to be pasted in?

Many thanks,

Andy

 

[ktab]

you use .clearcontents and clears validation also?

 

[asylum]

doh!

thanks-

i was using selection.clear, using selection.clearcontents works just fine - see i knew it was an easy solution, thanks!

Andy