ClearContents

B

buzz71023

Active Member
Joined
May 29, 2011
Messages
295
Office Version
  1. 2016
Platform
  1. Windows
I need to clear contents of several different ranges with a loop. I've done some research but cant figure out how to do it. All the ranges that need to be cleared are named ranges (JobSpecs, JobInfo, JobTest, EmailAddress). I know this is simple but I cant seem to get it right. Can someone help me figure this out? Thanks
 
Sort by date Sort by votes
Thanks for the help... Code seems to work great... Thanks everyone fore the replies...
 
Upvote 0
You must log in or register to reply here.

Similar threads

TAPS_MikeDion
  • Solved
How to find the last row with data within a range
Replies
7
Views
207
TAPS_MikeDion
TAPS_MikeDion
H
  • Question Question
VBA Loop to Copy Cell Value from worksheets to new worksheet with Worksheet Name
Replies
4
Views
170
saboh12617
S
4
  • Question Question
VBA to Print Labels but Issues Selecting Printer
Replies
1
Views
569
rpaulson
rpaulson
U
  • Question Question
Excel VBA, Loop, Copy, Loop, Paste, Autofilter, return value, Loop.
Replies
0
Views
394
user29383902
U
A
  • Solved
Sorting A Range of Cells Horizontally - Defining Dynamic Sort Range
Replies
5
Views
173
Ark68
A

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
Back
Top