Thread: Record deletion
View Single Post
  #1   Report Post  
Old December 7th 08, 10:54 PM posted to microsoft.public.excel.worksheet.functions
DDD DDD is offline
external usenet poster
First recorded activity by ExcelBanter: Oct 2006
Posts: 24
Default Record deletion

I have 2 questions

Is there any way to link a macro & cell together.
For example, i have a cell that has a kind of count down in days, updated
every day (open the spreadsheet today & its 10, open it the next day & its 9)
when the number within the cell reaches 0, it activates a macro that deletes
the entire row THAT the cell (that has 0 in it) is include within.

2)i have formulae from I5-I35 & K5-K35, is there any way, i cant stop these
getting deleted (From the method used above).

The result i want to get, is that i want a row to be selected & deleted
except the cells that have a formula in them. Then all the cells under this
move up 1 row (The formulae never move)

Sorry if this is hard to understand