Tag: last cell in column

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 , , , , ,

In this post I will simply show a few VBA tricks, for defining last used cell in a row (or column) and defining the size of the worksheet. Let’s assume that you wish to delete all the contents from a …

VBA – Defining last cells in row/column and size of spreadsheet Read more »