12 July 2020 Excel get user details of who open and close specific Excel file Macro Requirement The macro requirement is if some one opens specific excel file then we need to get the name[….] 000000
12 July 2020 Excel VBA code to data consolidation from multiple sheets Excel VBA code to consolidate data from the multiple sheets in one single Excel file How the Excel macro works[….] 000000
26 April 2020 Excel VBA code to Create Folders and Sub Folders Click here to download the workbook used in the below example. Copy below code and edit as per your requirement.[….] 000000
5 April 2020 Excel VBA code to remove duplicates Click here to download the workbook which contains the code Excel VBA code to Remove Duplicates Result Screen Print Copy[….] 000000
14 March 2020 Excel VBA Code for VLOOKUP Click here to download the workbook which contains the below code Copy below code and edit below VBA code as per[….] 000000
20 September 2019 Excel VBA Code to Change Fonts in Specific Range Click here to download the workbook which contains the below code Copy below code and paste it in the VBA Code[….] 111001
15 September 2019 Excel VBA code to Copy File from one location to another location Click here to download the workbook which contains the below code Copy below code and paste it in the VBA Code[….] 100000
9 September 2019 Excel VBA Code to Get All Sheets Names Click here to download the workbook which contains the below code Sheet Names Output Copy below code and paste it[….] 000000
6 December 2018 Excel VBA Code to change Font of the First 5 letters in a single cell Before After Suppose we have text “Commerce and Excel hub” in Cell B3 like the example shown. Now using VBA[….] 020000