Thread: Deleting Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ray Ray is offline
external usenet poster
 
Posts: 267
Default Deleting Cells

Hi Michael -

I've noticed this issue in workbooks where I have 'change event'
macros .... I think the macro fires EVERY time a cell changes and even
though you're deleting a range of cells, the macro may be firing for
every cell in that range. In other words, if you select a range that
is 5rows x 5columns, the macro doesn't fire once, but rather 25
times ...

On your last question .... are you truly deleting cells or just
deleting the contents? Do you want to do this via macro or ???

//ray