-
Recent Posts
- Excel VBA: Empty Clipboard Excel
- How to Get a Full File Path in Excel?
- Remove Non-AlphaNumeric Characters from String
- Sum Unique/Distinct Values in Excel
- Excel Extract Cell Comments
- How to get an Acronym using Excel VBA?
- Get Position of Last Column Containing Data with Excel VBA
- Find the Last Day of any Month
- Schedules to Refresh Data Automatically using VBA Macro
- Excel VBA Add Set of Worksheets Automatically
Category Archives: Workbook and Worksheet
Finding Cell with Minimum/Maximum Value in Active Worksheet
Let say we want to find position of cell containing the minimum/maximum value in current/active Excel worksheet, and then after we found the cell, we will change the cell format to make it stand out before other cells. The logic … Continue reading
Posted in Excel VBA Function, Workbook and Worksheet
Tagged cell function, excel formula, excel macro, excel tutorial, excel vba formula, Excel VBA Function, excel vba max, excel vba max value, excel vba max value in column, excel vba maximum value, excel vba minimum, learn excel, macro cell, maximum cell value, minimum cell value, vba cell, vba excel, vba macro, vba minimum
1,063 Comments
Automatically Protect/UnProtect All Worksheets
Tonight I want to automatically protect and unprotect all Microsoft Excel Worksheets in my Workbook with password, instead of doing it manually, I put these following Excel VBA macro code in my Workbook. Public Sub ProtectAllSheets() Dim objSheet As Worksheet … Continue reading
Create New Excel Worksheet With VBA
The Excel VBA macro below will create a new Excel Worksheet called ‘RawData’ or we can use msgbox to ask for the Worksheet name if needed. If there is already a Worksheet called RawData, user will be ask whether they … Continue reading
Posted in Workbook and Worksheet
Tagged create new worksheet vba, create worksheet vba, excel macro create new sheet, excel vba create new sheet, excel vba create new worksheet, excel vba new sheet, excel vba new worksheet, vba add worksheet, vba create new sheet, vba create new worksheet, vba excel create new sheet, vba excel create new worksheet, vba excel new worksheet, vba new worksheet, Worksheet
769 Comments