How to get the 'current row' from VBA
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
|