Please_H
Board Regular
- Joined
- Apr 16, 2017
- Messages
- 181
- Office Version
- 2019
- Platform
- Windows
Dear Experts of Mr.Excel,
Thanks again for all the Love and Support given in here...
Hope all of your Families and Friends are safe and sound from Covid-19.
This evening I am facing a new challenge having to do some formatting for countless number of Sheets and I am in a need of hand from the Experts of Macro.
Macro 1 - Once we Run, it :
01. Creates a Column Between 'Column (D)' and 'Column (E)'
02. Format all Cells to Calibri size 10
( Some Words and Numbers may be already Bold and some cells might have Formatting done with Borders and stuff. That Shouldn't Change )
03. Changes Column width to Column (A) : 20, Column (B) : 45, Column (C, D, E, F & G) : 17, Column (H) : 10
04. Copies Data from Sheet "IRFS16" Cell B3:H13 and Pastes ( Direct Copy Paste with Formatting and Equations and Stuff intact ) the Data to the Selected Cell at the time when the Macro was Run.
Macro 2 - Once we Run, it :
01. Changes Format for Selected Cells to "Accounting" with 2 Decimals.
Macro 3 - Once we Run, it :
01. Changes Alignment for Selected Cells to "Bottom Align".
Thanks a lot all of you...
Have a Great Day ahead...
Thanks again for all the Love and Support given in here...
Hope all of your Families and Friends are safe and sound from Covid-19.
This evening I am facing a new challenge having to do some formatting for countless number of Sheets and I am in a need of hand from the Experts of Macro.
Macro 1 - Once we Run, it :
01. Creates a Column Between 'Column (D)' and 'Column (E)'
02. Format all Cells to Calibri size 10
( Some Words and Numbers may be already Bold and some cells might have Formatting done with Borders and stuff. That Shouldn't Change )
03. Changes Column width to Column (A) : 20, Column (B) : 45, Column (C, D, E, F & G) : 17, Column (H) : 10
04. Copies Data from Sheet "IRFS16" Cell B3:H13 and Pastes ( Direct Copy Paste with Formatting and Equations and Stuff intact ) the Data to the Selected Cell at the time when the Macro was Run.
Macro 2 - Once we Run, it :
01. Changes Format for Selected Cells to "Accounting" with 2 Decimals.
Macro 3 - Once we Run, it :
01. Changes Alignment for Selected Cells to "Bottom Align".
Thanks a lot all of you...
Have a Great Day ahead...