* Mark Knecht <[EMAIL PROTECTED]> [050207, 18:39]:
> On 2/5/07, Ennio-Sr <[EMAIL PROTECTED]> wrote:
[...]
> Hi Ennio,
> First, and again, thanks for your help on this.
>
> [...]
> 1) The macro moves the current location of the active cell to the cell
> [...]
See my previous reply (I'm trying to work on Pitonyaks function ...)
>
> 2) Since my main spreadsheet page is a roll-up of a spreadsheet that
> is put out each week the values I see in my spreadsheet on sheet 1 are
> actually values on other sheets. My front sheet has values in it such
> as: =12_8_06.C43 where 12_8_06 is the name of another sheet in the
> file and C43 is the cell number on that page I want to see on this
> main page. As the macro
I presume you're talking about the macro I called 'cptoa1' ?
> sits right now it doesn't copy what I see in
> my main spreadsheet but rather copies the equation that references the
> other page. Can you see how to copy the contents of the other page at
> the location in the current cells instead of the equation in the
> current cell?
>
May be you have to un-mark the 'Formulas' box under the Display column
in Tools/Options/Calc/View?
Mind you that reference to formulas contained in same sheet/other sheets
must be to their 'absolute address', otherwise you get a different value
in cell $A$1.
So, in you main spreadsheet page you should use =$12_8_06.$C$43
Please, confirm my assumption is correct.
Ciao,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
