Count Rows/Columns in folder

Hey guys,
I’m new to Visual Basic and I want to create a macro that will read excel files within a folder and will count the number of rows and columns. Then it will output the Name/Number of Rows/Number of columns into the current excel file.
So output will look like this

Excel File Name Number of Rows Number of Columns

I have managed a macro to read the files and columns but the output is giving me a hard time.


any help would be great! thanks in advance!

Please Login or Register  to view this content.

Thanks in advance!!

You're getting the usedrange - why not just rows.count and columns.count?

You're using the ActiveSheet for both - you need to differentiate!