How to get the 'current row' from VBA
I have an answer already in another thread.
But your solution (as far as I can tel) has a focus problem.
Meaning: when I want to start a macro I don't care which cell has the focus.
I want to start a macro whith that specific row.
Again the solution presented in the other thread works fine.
Thanks.
"Kevin" schreef in bericht
...
ActiveCell.Row will return the row of the active cell.
Use offset(0,X) or Sheets("sheet1").Cells(RowNum, X)to
read/store values in cells of the same row.
Is that what you're looking for?
kpd
-----Original 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
.
|