Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Clear specified cells
- Thread starter ali32j
- Start date
HarleyQuinn
Programmer
In your command button's click event use:
Hope this helps
HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman
Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.
Code:
Range("B2:E2500").ClearContentsHarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman
Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.
- Thread starter
- #3
Thankyou thats perfect
One other questions, is it possible to automatically enter a formula in a cell if a value is present? i am trying to automate the process to prevent user mistakes, so in column AA, if value present in column Z, then paste formula, if no value then stop
One other questions, is it possible to automatically enter a formula in a cell if a value is present? i am trying to automate the process to prevent user mistakes, so in column AA, if value present in column Z, then paste formula, if no value then stop
SkipVought
Programmer
ali32j,
Please start a new thread for a new question unrealted to the thread.
You might also click the link...
[blue]
Thank HarleyQuinn
for this valuable post!
[/blue]
Skip,
[sup]![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Don't let the Diatribe...
talk you to death!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]
Please start a new thread for a new question unrealted to the thread.
You might also click the link...
[blue]
Thank HarleyQuinn
for this valuable post!
[/blue]
Skip,
[sup]
Don't let the Diatribe...talk you to death!
[/sup][sub]Just traded in my old subtlety...for a NUANCE!
[/sub]
HarleyQuinn
Programmer
Hmm, I don't have that link on my screen Skip...
HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman
Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.
HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman
Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.
SkipVought
Programmer
we'll leave the self agrandizing to the pub, after hours, and quaff a pint on me. ;-)
Skip,
[sup]
Don't let the Diatribe...talk you to death!
[/sup][sub]Just traded in my old subtlety...for a NUANCE!
[/sub]
HarleyQuinn
Programmer
![[cheers]](/data/assets/smilies/cheers.gif "[cheers] [cheers]")
HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman
Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question