Tag: Last Used Row in Excel

By Posted on Posted in C Sharp Tricks, VBA \ Excel Tagged with , , , ,

Getting the last row of a given column in Excel with a formula or with VBA is quite a trivial task. It is explained here quite well 🙂 However, when we come to C#, the only “trick” that is provided …

C# – How to get the last filled cell of a given row in Excel Read more »

By Posted on Posted in VBA \ Excel Tagged with , , ,

Getting the last row of a given column in Excel is easily done with a User-Defined Function in VBA: Function LastRow(wsName As String, Optional columnToCheck As Long = 1) As Long Dim ws As Worksheet Set ws = Worksheets(wsName) LastRow …

Last Used Row (Last Used Column) in Excel with Formula (without VBA) Read more »