PutBlock problem

{PutBlock @PROPERTY("Active_Page.Name"), B7} puts a formula in to B7
wich 
gives ERR  when page name starts whith a number (25_3rd_st). All I need in 
B7 is a label of the page name.
Any ideas?

Jeff 

Jeff wrote:
> {PutBlock @PROPERTY("Active_Page.Name"), B7} puts a formula in to
B7 wich 
> gives ERR  when page name starts whith a number (25_3rd_st). All I need in

> B7 is a label of the page name.
> Any ideas?

The ERR stems from the quirky manner in which  enters data into a 
cell:  using your syntax, the page name is entered into the target cell with a 
preceding plus sign, which will return ERR unless you have a range named
25_3rd_st.

Your alternatives would be either:

   +"{PutBlock
""'"&@PROPERTY("Active_Page.Name")&""
", B7}"

or, more simply:

   {LET B7,@PROPERTY("Active_Page.Name")}

Cheers,
Uli

Same problem in x3.  Use  as an alternative.

Good alternatives Uli.

Another:
{PutBlock "'"&@PROPERTY("Active_Page.Name"), b7}

+"{PutBlock
""'"&@PROPERTY("Active_Page.Name")&""
", B7}"
with ReCulc did the job.
Thank you.
Jeff
"Uli" <nojunkmail@spamless.com> wrote in message
news:47bf2924_2@cnews...
>
> Jeff wrote:
>> {PutBlock @PROPERTY("Active_Page.Name"), B7} puts a formula
in to B7 wich 
>> gives ERR  when page name starts whith a number (25_3rd_st). All I need

>> in B7 is a label of the page name.
>> Any ideas?
>
> The ERR stems from the quirky manner in which  enters data into 
> a cell:  using your syntax, the page name is entered into the target cell 
> with a preceding plus sign, which will return ERR unless you have a range 
> named 25_3rd_st.
>
> Your alternatives would be either:
>
>   +"{PutBlock
""'"&@PROPERTY("Active_Page.Name")&""
", B7}"
>
> or, more simply:
>
>   {LET B7,@PROPERTY("Active_Page.Name")}
>
> Cheers,
> Uli
>