Show sheet name

-
Sub MsgBoxAllMySheets()
    Dim sht As Worksheet
    For Each sht In Sheets
      MsgBox sht.name
    Next sht
  End Sub

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

Google Analytics4 Data Extract using Python

-
Image
  The SERVICE_ACCOUNT_FILE in the script refers to the JSON key file of a service account that has permissions to access the Google Analytics Data API. This file is essential for authentication and should be downloaded from the Google Cloud Console. Steps to Obtain the SERVICE_ACCOUNT_FILE Create a Service Account : Go to the Google Cloud Console. Navigate to IAM & Admin > Service Accounts . Click Create Service Account . Assign Permissions : Assign the role "Analytics Data Viewer" to the service account. Create a Key : After creating the service account, click on it to open the details. Go to the Keys tab and click Add Key > Create New Key . Select JSON format and click Create . This downloads the key file to your computer. Grant Access to the GA4 Property : Go to your GA4 account. Navigate to Admin > Account Access Managemen...
Read more