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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Conditional formatting 5
Excel - Wich Function should I use? 1
VBA: Programmatically clear a one-key shortcut bound to a document 2
How to format Green conditionally b1 if a1 is only Green? 4
How do I clear a form? 0
how to add a combolist drop down to each row 2
how to allow other users to make changes for some perticular cells 2

Top