Deleting Variable Ranges

B

bobclark

This is what I would like to accomplish:

current cell
end down
lock range
delete the contents of the range

The ranges vary each time I want to clear them.

Thanking all of you in advance

HTH
Bob
 
D

Dave Peterson

I'm not sure what Lock Range means, but...

dim myRng as range
with activesheet
set myrng = .range(activecell,activecell.end(xldown))
myrng.clearcontents
myrng.locked = true '???
end with
 
D

Dave Peterson

You made me laugh!

(Quiet Deb! He has a right to his opinion--no matter how misguided!)
 
Top