Thread
:
clear ranges
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
clear ranges
OR this with no loop and no selections.
with Range("a1:b2,c4:d5,etc")
.ClearContents
.ClearComments
end with
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Striker" wrote in message
...
I have about 40 named ranges in a sheet. I need do quickly do a ,loop and
clear all named ranges. currently I am clearing like this, but it is
getting too long to do with all the ranges. not sure how to assing a range
name to a variable and clear it.
With ActiveSheet
Range("ONE").Select
Selection.ClearContents
Selection.ClearComments
Range("TWO").Select
Selection.ClearContents
Selection.ClearComments
Range("THREE").Select
Selection.ClearContents
Selection.ClearComments
end with
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett