SpreadCE / Spread32

With out clicking the first visible column (not the freeze pane), How can I obtain with a macro the number column of the first visible one?

That is a good question.

Microsoft Excel has a macro function (GET.WINDOW) which returns such values, but I have not yet implemented the corresponding function in Spread32.

While I try to find an alternative way to derive it in the current version of Spread32, please can you tell me why you need to know which is the leftmost scrollable column? There may be an alternative solution to what you want to achieve.

I find a date (with find function) and change a value in that column. I want to return to the same view that the user was before the macro starts.The column A is freeze.
Regards,
Daniel

I have to select a cell (student name) in column A (freeze) because if I select the column in the righ(first column show)t I could know witch column is and return back after the macro, but thats not what I want.
Regards,
Daniel

I have now implemented the GET.WINDOW macro function.
Please let me know which version of the software you are using and I will send a copy of it to you.

I have ver 2.02.
I will download the trial 2.03 version
INow I have other problem: get.note send me an error. If I am using it the wrong way can you write me a short example.
Thanks
[/b]

I will send you a copy of the 2.04 version, which contains the GET.WINDOW macro function.

The GET.NOTE function fetches the comment text associated with a cell. The general form is:
GET.NOTE( cell_reference , start_position , length )

If you don't enter the cell reference then the function will use the active cell (that is the current cursor cell on the currently displayed sheet).

You can use the start position and length parameters to select just a part of the comment.

On a macro sheet, the function:
=GET.NOTE()
will retrieve the comment text from the active cell, and store it as the result of the formula. You can see it by using the Format > Sheet > Formulas menu option to switch the display between the formulas and the values.

Or you can use the function as part of a more complicated formula, such as:
=ALERT(GET.NOTE())

To retrieve the text for a particular cell, use it like this:
=GET.NOTE(Sheet1!A1)

To retrieve just a part of the comment text, use it like this:
=GET.NOTE(,10,5)
This fetches 5 characters of the comment text, starting at position 10.

I will send you an example file.