Hi James,
If you want to make data in range become dissapear,
you can do by :
Range("yourrange").clearcontents

but if you want to make it reappear in an action you can see
onundo function from VBA but if you do deletetion you may
lost your data ...
It means onUndo function is only once.

Regards,

Halim

--

Regards,

Halim


"james" wrote:

Okay. So, at one point in time I used a spreadsheet that had a buttton built
into the spreadsheet that made all rows with no data in column e dissappear.
I am an idiot but i need to do this to my order forms. Then it had another
button that made it reappear.