Hi,

I want to execute a macro and let it read/store some values in de current
row.

My intention was to place a graphical object in a row, attach the macro to
it
and let the macro 'dectect the "current row'' and read/store values row
related.
And do this for several rows, that all execute the same macro.

How to solve this or are there smarter solutions!
(I want to execute this for any single row)


Regards Peter

Hi Peter

Check out the TopLeftCell/BottomRightCell property.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

"Peter van de Kerkhof" skrev i en meddelelse
.. .
Hi,

I want to execute a macro and let it read/store some values in de current
row.

My intention was to place a graphical object in a row, attach the macro to
it
and let the macro 'dectect the "current row'' and read/store values row
related.
And do this for several rows, that all execute the same macro.

How to solve this or are there smarter solutions!
(I want to execute this for any single row)


Regards Peter

I.'m sorry Leo but that didn't help me much.

Yes I've found the TopLeftCell/BottomRightCell property but don't know how
to apply it.


Can you give a sample like:

sub Updateline()
summarybook = Excel.ThisWorkbook.Name
MsgBox Workbooks(summarybook).Worksheets(DevList).TopLeft Cell
end sub

regards Peter

"Leo Heuser" schreef in bericht
...
Hi Peter

Check out the TopLeftCell/BottomRightCell property.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

"Peter van de Kerkhof" skrev i en meddelelse
.. .
Hi,

I want to execute a macro and let it read/store some values in de
current
row.

My intention was to place a graphical object in a row, attach the macro
to
it
and let the macro 'dectect the "current row'' and read/store values
row
related.
And do this for several rows, that all execute the same macro.

How to solve this or are there smarter solutions!
(I want to execute this for any single row)


Regards Peter

In addition, to determine which graphical object was called, use the
application.Caller property in attached macro. It will return a string with
the name of the graphical object that fired the macro.

Regards,
Tom Ogilvy


Peter van de Kerkhof wrote in message
.. .
Hi,

I want to execute a macro and let it read/store some values in de current
row.

My intention was to place a graphical object in a row, attach the macro to
it
and let the macro 'dectect the "current row'' and read/store values row
related.
And do this for several rows, that all execute the same macro.

How to solve this or are there smarter solutions!
(I want to execute this for any single row)


Regards Peter