I have a cell that needs to count the number of occupied cells that can vary based on user needs.
For example, user enters additional columns into the sheet by putting text in first row. I need to count the number of cells they modify and put that number in a specific cell.
How could I capture this? Could I use a formula? Or trap some kind of event in VBA? Any other suggested approaches?
You can't just use COUNTA?
I guess it all depends on what you are actually capturing that number for.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
CountA looks like what I need. I wasn't aware of that function. Thanks Domski.Originally Posted by Domski
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks