identifying last value in a row.
Posted on 2011-10-07
I have a VBA app (Excel), in which I need to identy the column notation (A, B,...) of the last value in a row. (I need to then insert that value in a subsiquent formula.) I already know which row to test on.
I would go to specific row and then determione the column notation value (lacall).
Then I would do a copy&paste operation as such:
SourceSh.Range(lacall & (958 + ioffset) & "." & lacall & (963 + ioffset)).Copy
r.Offset(0, 63).PasteSpecial xlPasteValues, , , True
Curently I retrieve LACALL from the user's workbook entry. Would be better If I figure it out.