VBA Macro To Find Count of No.Of Sheets In A Active WorkBook
Sub Count_Shts()
Mycount = Application.Sheets.Count
MsgBox Mycount
End Sub
Sub Count_Shts()
Mycount = Application.Sheets.Count
MsgBox Mycount
End Sub
Subscribe to:
Post Comments (Atom)
Featured Post from this Blog
How to compare Current Snapshot Data with Previous Snapshot in Power BI
How to Dynamically compare two Snapshots Data in Power BI Scenario: Suppose, we have a sample Sales data, which is stored with Monthly Snaps...
Popular Posts from this Blog
-
Microsoft Power BI Themes Colors with Hex Codes Reference -------------------------------------------------------------------------- List... -
SQL Query to Calculate the Cumulative Sum or Running Total Scenario : Suppose we have a Table " TblSample " as follows.. ... -
How to get the All Selected Values from a Slicer using SelectedValue, AllSelected, and ConcatenateX Functions in Power BI Scenario : Supp... -
How to Handle the Row yielded no match during lookup and Row disposition Errors in SSIS Lookup Transformation Scenario : Suppose we have ... -
How to Dynamically Create an Excel File with Date Time from SQL Server Table using SSIS Package on each Execution Senario : Suppose I hav... -
How to use a Trigger to check if a record exists otherwise Insert into a Table in SQL Server Scenario: Suppose we have to tables as , ... -
How to Schedule and Refresh an Azure Analysis Service Model using Azure Data Factory 1) Add Azure Data Factory as Managed Identity to the Az...
-
Excel VBA Macro To Add Cell Contents In Comment Box The Following Macro is Designed to Perform a Requirement in Reporting.From the Follo...
-
How to Dynamically compare two Snapshots Data in Power BI Scenario: Suppose, we have a sample Sales data, which is stored with Monthly Snaps...
-
How the GROUPBY and CURRENTGROUP Functions will work in Power BI DAX The GROUPBY function is similar to the SUMMARIZE function. However, G...
No comments:
Post a Comment
Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.