It appears that when you specify the columns in the .UsedRange property
it returns the entire used range in the column to your c variable.
Then the checking for locked will not work (since the entire range i
not locked). You will need to specify your range in a different manor
Something like:

Dim BigRange as Range
Set BigRange = Range("A1:G" & Range("G65536").End(xlUp).Row




--
Message posted from http://www.ExcelForum.com