Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Hi all,

this is my first e-mail in this mailing-list.

i've create this macro.

Sub SheetContentChange(oCallingCell)
    Dim addr as variant: addr = oCallingCell.getRangeAddress()
    Dim col, row as integer

    For col = addr.StartColumn to addr.EndColumn step 1
        For row = addr.StartRow to addr.EndRow step 1
CellContentChange(ThisComponent.CurrentController.ActiveSheet.getCellByPosition(col, row))
        Next row
    Next col
End Sub

this macro start on Sheet Events - Content Change.

It's receive a Cell, if I select a range (single range - For example F5-F12), it's works.
But if I select multiple ranges, for example  f5-f12;h30-h32, I get error.

Someone could, please, help me ?

Thanks a lot.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.