VBA Macro to Add Column Headings As Worksheets in Excel
Sub Mac_Headings()
Dim x As Integer
For x = 1 To 5
Sheets.ADD.Name = Sheets("AAA").Cells(1, x)
Next x
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
-
SQL Arithmetic Overflow Error Converting Varchar to Data Type Numeric The Arithmetic Overflow Error occurs when converting a numeric or ...
-
Microsoft Power BI Themes Colors with Hex Codes Reference -------------------------------------------------------------------------- List... -
How to get the All Selected Values from a Slicer using SelectedValue, AllSelected, and ConcatenateX Functions in Power BI Scenario : Supp... -
How to use Commit, Rollback and SavePoint commands in SQL Server The Commit, Rollback and SavePoint are the Transactional Controlling Lang...
-
How to Handle the Row yielded no match during lookup and Row disposition Errors in SSIS Lookup Transformation Scenario : Suppose we have ... -
How to use Dim and ReDim Statements in VBA Dim Statement: Variables declared with Dim at the script level are available to all proced...
-
How Run or Stop a Macro with VBA Input Box and Message Box Responses Sub Run_Stop_Macro() Alert = MsgBox("The Macro will Update the...
-
How to generate Random numbers using rnorm(), runif() and sample() Functions in R rnorm () : The rnorm() function is used to generate n ... -
Python Program to display the numbers from 1 to 100 in 10 rows and 10 cols for x in range(1, 11): for y in range(1, 11): print(&...
-
Removing a Carriage Return, Line Feed (CRLF) from a Column in SQL Server The term CRLF refers to Carriage Return (ASCII CHAR(13), \r) Li...
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.