excel - how to capture cell address as a variable and use in VB code ...

Select ' collect the row number into a variable lastRow = ActiveCell. ... How can I change the position of the active cell (or raise the value with one) in Excel.

stackoverflow.com