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
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
=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
Dear CLR,
Thank you for your response. But I want to copy from excel to word, Then
what should i do?
"CLR" wrote:
> =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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks