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.
没有评论:
发表评论