Hi Martin, After you select your range (which may include the hidden cells) try to press Alt + ;.
This selects only visible cells. Once this is done, you can clear your range. If this does not work, you'll have to create a macro which will unprotect your worksheet, clear the required range and then protect the worksheet again. Regards, Sandeep On 7/26/09, Durbat <durb...@googlemail.com> wrote: > > Hi > > Hope this makes sense and I'm not posting wrong group but I've failed > on something I thought was going to be easy. > > I have a large spreadsheet into which childrens test scores are added. > I have hidden columns which do some analysis of the scores and display > the results in an other visible column. > > I have protected the sheet such that data can be added as the tests > are completed but the hidden formula cells can't be amended. > > My problem occurs when I try to clear a selection of cells which span > the hidden, protected cells I get the usual message about unprotecting > the sheet first which defeats the objective of trying to prevent > accidental erasure of the formulea. > > Is there any way of "ignoring" the protected cells to allow large > portions of data to be cleared quickly? > > Thanks for any responses > > Martin > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
