Hi Everyone,
I have a very simple but time consuming process when working on some of my Excel Worksheets. I have been browsing here to see if there is someone with similar problem, but so far not found any. During my work I have several Formatting things I do, over and over and over again, but not been able to "Record" and reuse them as a Macro.
I use the "Group" functions to create "sub-groups" for easy or update, filter and view of the information.
Here is a list of the functions I want to do:
1. Insert 2 lines above the cell I am running the VBA from. (This cell would typically be "Grouped" and typically 2nd level)
2. Line 1, Will be "level1" using the Group function, 2nd line is a sub of Line 1.
3. Line 1, "Merge & Center", all cells from Column A to X, then "Outline border", Then "Align" Text LEFT, then set background color to "Dark Blue Text2".
4. Line 2, Add "all Lines Borders" to cells from A to X, and set background color to "Olive Green Accent 3".
The plan is to add this macro to my "Quick Access Toolbar", and simply click-n-run this as needed.
I have a very simple but time consuming process when working on some of my Excel Worksheets. I have been browsing here to see if there is someone with similar problem, but so far not found any. During my work I have several Formatting things I do, over and over and over again, but not been able to "Record" and reuse them as a Macro.
I use the "Group" functions to create "sub-groups" for easy or update, filter and view of the information.
Here is a list of the functions I want to do:
1. Insert 2 lines above the cell I am running the VBA from. (This cell would typically be "Grouped" and typically 2nd level)
2. Line 1, Will be "level1" using the Group function, 2nd line is a sub of Line 1.
3. Line 1, "Merge & Center", all cells from Column A to X, then "Outline border", Then "Align" Text LEFT, then set background color to "Dark Blue Text2".
4. Line 2, Add "all Lines Borders" to cells from A to X, and set background color to "Olive Green Accent 3".
The plan is to add this macro to my "Quick Access Toolbar", and simply click-n-run this as needed.
