Anyone know why a locked sheet would not allow the following VB to run -
I get an error at the Selection.clear contents point (although the sheet
is locked only formulae are locked, and they are not near these cells"
Point of the formulae to is to delte (formats and contents of 24c5 to
28c6

Sheets("Review Plan").Select
Application.Goto Reference:="R24C5:R28C6"
Application.CutCopyMode = False
Selection.ClearContents
Selection.ClearFormats

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!