Hello:
I have closed file C:\Temp\Book1.xlsb and it has data in sheet "Data" as shown in attached file.
I need VB Code to find the 1st blank row # in column A.
In this case the answer needs to be 18
Please let me know if you have any questions.
Thanks.
Riz
Try this code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
This can also be done with a simple formula
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello Yasser:
Thanks a lot, it works
Alkey: How would you use the above formula to bring row # from closed workbook? Would appreciate if you can explain.
Riz
I am very sorry Riz. I should've read carefully the description about closed workbook. You would need VBA for this.
You're welcome. Glad I can offer some help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks