Count cells in a range in vba

[Legacy 206167]

Just got stuck on what seems like a basic bit of code.

I have the following declared:

Dim Altsheet As Excel.Application

Set AltSheet = CreateObject("excel.application")

Using filedialogpicker a file is selected, which then is opened within Altsheet.

In the file that has been opened there is a range called "SectionName" on a sheet called "Inputs"

All I want to do is count the number of cells within "SectionName".

I've tried:

Altsheet.worksheets("inputs").range("SectionName").count

and other variations on this, but to no avail.

Help please...

Thanks in advance.

 

[patel45]

numcells=Altsheet.worksheets("inputs").range("SectionName").Cells.count

 

[Legacy 206167]

Thanks for the reply.

Unfortunately that gives an application-defined or object-defined error.

I'm stuck.

 

[patel45]

It works on my test wb, please upload a sample file on a sharing site, then paste the link here