Greetings, everyone! First, I would like to thank all of the people contributing to the mountain of knowlege on this site - you all have saved me time, money & hair with your advise/answers!

I have searched through the site and having trouble finding an answer to this specific problem. I am looking for a formula (or macros) to copy only unlock cells in a worksheet that has mixed cells (to be pasted on a separate worksheet) - does one exist? When I try it (old fashion) - it informs me that "that function cannot be performed on mulitple selections". I need it available to mulitple worksheets whose lines change, but not the columns. I found the macros code in an eariler post to select only unlocked cells, but to my dismay I cannot copy them.

Is this possible at all?

Thanks so much!