When you copy Data into Excel Sheet or if Data present in your Excel Sheet contains some blank Cells, then removing those blank cells one by one can be cumbersome task. So, For example you have situation as above where you wanted to delete Blank cells in A & B working columns. First Select any of …
So, If you have Data as in Column A and Wanted to split into Column in B & C as below, then use this super cool “Text To Columns” feature in Excel. First Select Column ‘A’ Column cells from A2 to A14. In Data ribbon Tab as below inside ‘Sort & Filter’ panel Click on …
Text To Columns to Split Text in Different Columns of Excel Read More »
This is in Continuation with our Previous Post Get List of All Files inside a Folder-Excel VBA Here we have added Sub Main and put Sub FilesInsideFolder outside main sub . sub clearCells is to clear all cells before running FilesInsideFolder sub routine. Starting Row changed from r=2 to r = Cells(Rows.Count, “A”).End(xlUp).Row + 1 because now when …
Get List of All Files inside Main & Sub Folder – Excel VBA Read More »
Go to Tools > Options … Editor: You can change Code Settings and Window Settings from ‘Editor’tab. Editor Format: You can change Code colors of different text, font and Text Size from here. General: There are some general properties of VBA editor that you can change from this tab. Docking: You can change Docking options by selecting …
Lets us Edit our recorded Macro and Study it: So Go to View > Macros > click ‘View Macros’ and on Macro dialog box Select our ‘MyFirstMacro’ and Click on ‘Edit’ tab. You can rename Macro by editing Macro name in From Sub Macroname() Sub MyFirstMacro() ‘ ‘ MyFirstMacro Macro ‘ This is my First Macro. …
How to Record Macro in Excel 2013 ? You can To Record Macro in Excel, Open Excel 2013 application. On Workbook click on ‘View’ Menu then open Drop down list from Tab Macros > Select Record Macro. This will open Record Macro Dialog box: Alternate Method: You can directly open Record Macro dialog …
If you have installed Excel 2013 on your Computer then Go to Start Button or press Windows tab from Keyboard. Type or Search Excel 2013 and click on it. On Application window Left side Recent files are shown if you have opened some of Recent files earlier then those will be shown for easy finding. …
