Off Canvas Menu

All
VBA
Python
Else
- C#
Reviews
- List of reviews
YouTube
PayPal
About

Tag: last cell in column

Home › Posts tagged last cell in column

C Sharp Tricks, VBA \ Excel

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

Vitosh Apr 11, 2019 Tagged with C#, Excel Interop, last cell in column, last used cell, Last Used Row in Excel

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 →

VBA \ Excel

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

Vitosh Mar 22, 2014 Tagged with Excel, last cell in column, last cell in row, last cell value, last used cell, VBA

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 →