My first row has X filled cells counting from A1. I want to get a reference to the second to the last cell (so if C1 is the last filled, I want B1, if U1 is the last filled I want T1).
Here’s corresponding VBA code:
Fu…...GetSecondToLast() As Range Set GetSecondToLast = Range(“A1”).End(xlToRight)...@artokilponen , You may get the range by code: Cells cells = ... int...