Please help...
Why can't I write this:
like this:lCount = WorksheetFunction.CountA(Range("M4").EntireColumn)
??lCounty = WorksheetFunction.CountA(Range(Cells(4,13)).EntireColumn)
Thanks
Please help...
Why can't I write this:
like this:lCount = WorksheetFunction.CountA(Range("M4").EntireColumn)
??lCounty = WorksheetFunction.CountA(Range(Cells(4,13)).EntireColumn)
Thanks
Hello machado,
When you use Range it expects an address. When you use Cells it expects a row and column. The Cells property is returning a value to the Range object that is not an address. The two methods below are the same:
lCount = WorksheetFunction.CountA(Range("M4").EntireColumn) lCount = WorksheetFunction.CountA(Cells(4, 13).EntireColumn)
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks