I am trying to pull the count on how many files are in a certain folder. I have a list of the folder names in column A and want the count in column B. I am having trouble with the code I have right now.
I am new to VBA, so when I use this macro nothing happens.
Please Login or Register to view this content.
Hello KColgrove,
Here is one way to do it...
Please Login or Register to view this content.
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 Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
This worked for me. I know this wasn't the original question asked, but it there a way to hover over the number and it display what the files are?
Hello KColgrove,
This version of the macro adds a Comment to each cell in column "B" to display the files when you mouse over the cell.
Please Login or Register to view this content.
That works perfectly. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks