how can i clear a perticular range using a function...???

S

Saleem Hyder

i need to clear a perticular range again n again. which too dificult kindly
help me if there is any function or any other function related this.
thanks
 
G

Gary''s Student

Two ways:

1. first assign a Name to the range and then you can select the range by
Name then then:

Edit > Clear

2. create a macro that clears the range and assign a shortcut key to it.
 
Top