How to Find Last Column Index in Excel

Hello Friends,

Is there any way where we can find last column in Excel, Like for example, Excel have data in Column from A1 to AB1 so here output should be AB or AB1, next time data may end in different column.

Thank you.

we do have different options e.g.:

  • read range and refering to the columns count
  • Balareva:

Read it into a datatable and get yourDT.Columns.Count