I would like some help with the following code. I use it to add rows on a spreadsheet then clear contents of specific cells but keeping the cells that have a formula in. I'd like to add an input box to allow me to specify the number of rows to add but still clearing the specified cells. so if I add 10 rows and happen to copy a row that already has content in then I would like to clear that content but keep the formula. the active cell could be anywhere in the range from a to T which is why I initially select column "A" before clearing contents (this was the only way I could figure out the offset)
Sorry if I'm not making this very clear and thanks in advance.

Mick 

Please Login or Register  to view this content.