hello everyone, i have a column from a2:a2000
i want to save a file that counts how many cells from a2:a2000 have data
so basically, if A2:A197 have data, i want the file name to be "Dec (15) DB (197).xls
i am using this code but its not counting for some reason
anyone have an idea why?
Please Login or Register to view this content.
thanks for your help
What are you using to populate lnglastrow?
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.
Hi Dom, im using numbersOriginally Posted by Domski
What I mean is lnglastrow is a variable name that will not contain a value until you give it one.
This would normally be done like this:
You would need to change Sheet1 to the sheet name that contains your list.Please Login or Register to view this content.
Dom
Excellent, working great, you are really good my friendWhat I mean is lnglastrow is a variable name that will not contain a value until you give it one.
This would normally be done like this:
You would need to change Sheet1 to the sheet name that contains your list.Please Login or Register to view this content.
Dom
thanks again
one problem Dom, i like the count to start from A2, not A1What I mean is lnglastrow is a variable name that will not contain a value until you give it one.
This would normally be done like this:
You would need to change Sheet1 to the sheet name that contains your list.Please Login or Register to view this content.
Dom
nevermind, i figured it out Dom
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks