Create a New Workbook containing only one sheet

-
Workbooks.Add xlWorksheet
 set newwb = workbooks.add(1)
 set newwb = Workbooks.Add(xlWBATWorksheet)

Comments

Post a Comment

Popular posts from this blog

useful site link

-
Books Americabookshelf.com – One of the largest book exchange clubs across the US. BooksConnect – A book sharing community site connecting readers, authors, publishers, librarians and booksellers. BookCrossing.com – A community of users from over 130 countries who exchange books with each other at public places like cafes, parks etc. Bookhopper.co.uk – Free community for UK residents to share used books with each other. Bookins.com – Book sharing website that enables members to exchange used books with each other in real time. BookMooch.com – An interesting concept where users can exchange books with others through points. Users gain points when they give books to others. Booksalescout.com – Online community of users allowing them to sell books in the US. Bookswim.com – Book borrowing service with free shipping for registered website. ConnectViaBooks – A social networking site connecting book lovers and enabling them to discover other similar in...
Read more

Extract the frist name & last name in Excel

-
Example:- Rajeev Ranjan Kumar:-  O/p first name;- = IFERROR(LEFT(A21,(FIND(” “,A21))-1),A21)    mid name;- = MID(A21,FIND(” “,A21)+1,FIND(” “,A21,1+FIND(” “,A21))-FIND(” “,A21)-1) last name:- = RIGHT(A21,LEN(A21)-FIND(” “,A21,FIND(” “,A21)+1)) here “A21″ is a cell value ref.
Read more