View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default Copy from Protected sheet

=Sheet1!A1 will return the value in sheet 1 cell A1 whether Sheet 1 is
protected or not. It can be copied to adjacent cells to expand the range.

It can also be used in formulas, like =SUM(Sheet1!A1,Sheet1!A2)

hth
Vaya con Dios,
Chuck, CABGx3



"Rao Ratan Singh" wrote:

Hi all,
Is there any way to copy a specific range from protected worksheet. Because
I have formulas in this sheet. when i copy a specific range it may be delete
or currupt.

so pls give me a solution.

Rao Ratan Singh