clearing cells

V

vertx93

New Member
Joined
Sep 19, 2014
Messages
1
Hi everyone, New here..

I would like to know how to clear a range of cells (eg. A1 to E5) when changing another cell (eg. F1) thanks!!
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
steve the fish

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,849
Office Version
  1. 365
Platform
  1. Windows
This in the worksheet module should do it (right-click on the sheet tab and press view code):

Code: 
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$1" Then
Range("A1:E5").ClearContents
End If

End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
How to Clear a Cell Based On Another Cell
Replies
3
Views
366
Joe4
Joe4
M
  • Question
Macro to detect and change color of text and to change color of text after a symbol
2
Replies
12
Views
1K
Zot
Z
J
  • Solved
multiple two cells based on text in another cell
Replies
2
Views
520
jimjim001
J
nitrammada
  • Solved
VBA - Clear all rows below if
2 3
Replies
23
Views
2K
Michael M
Michael M
R
  • Solved
Clear cell contents if another cell changes
Replies
3
Views
4K
Joe4
Joe4

Forum statistics

Threads
1,190,568
Messages
5,981,714
Members
439,733
Latest member
Ahmed8054

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top