So troublesome VBA in EXCEL

When I was processing a EXCEL sheet, I found that the works by hand was troublesome. So I wanted to use VBA, the built-in language in EXCEL. But when I wanted to solve the colomns' count, I had found for this function for three hours.

It is troublesome. But when I looked at the correct answer, I felt exciting.

This function could be relised by the following code:

colomnum=cells(1,1).currentregion.Columns.Count


It looks like so easy, but I know its true meaning.