GOTO

[David Wheeler]

On my macro sheet I have a cell named Next_Blank_Sheet which stores the
location of the top left cell on the first blank sheet in the book eg
F:A1. I want to jump to that cell. I've tried all sorts of variations
on {GOTO Next_Blank_Sheet} but the cursor keep moving to the cell named
Next_Blank_Sheet not to the location it points to. What is the correct
syntax.

thanks again
David

[lemoto]

David:

> On my macro sheet I have a cell named Next_Blank_Sheet which stores the
> location of the top left cell on the first blank sheet in the book eg
> F:A1. I want to jump to that cell. I've tried all sorts of variations
> on {GOTO Next_Blank_Sheet} but the cursor keep moving to the cell named
> Next_Blank_Sheet not to the location it points to.

Well, since you just told it to, I guess it would.-)}

Try: +"{SelectBlock "&~Next_Blank_Sheet&"}"
--
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

[David Wheeler]

lemoto wrote:
> David:
>
>>On my macro sheet I have a cell named Next_Blank_Sheet which stores the
>>location of the top left cell on the first blank sheet in the book eg
>>F:A1. I want to jump to that cell. I've tried all sorts of variations
>>on {GOTO Next_Blank_Sheet} but the cursor keep moving to the cell named
>>Next_Blank_Sheet not to the location it points to.
>
>
> Well, since you just told it to, I guess it would.-)}

Fair enough. I had also tried quotes and ampersands and combinations
thereof.

>
> Try: +"{SelectBlock "&~Next_Blank_Sheet&"}"

That works. So does.

'{EditGoto +Next_Blank_Sheet}

cheers,
David

[lemoto]

David:
> That works.

Good-oh!

> So does.
> '{EditGoto +Next_Blank_Sheet}

Not here.-(}
{EditGoto ~nextblanksheet} (my cellname, through idleness)
does.