Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 205
- Office Version
- 2019
- Platform
- Windows
I have 27 sheets in my Excel file, One sheet is RAW DATA and other sheet is COUNT, I want a macro code for other 25 sheets.
1. I want the column width size - column A =17 Column B = 30 Column C = 15 Column D = 12 Column E Auto Fit Column F = 25 Column G = 7 Column H = 10
2. If the page is more than 2 then Print Tiles - rows to repeat at top is 1st row A1 to H1.
3. And dark line Borders Inside and outside each cell where the Data available till the last row, I have data in all sheets from A to H.
Kindly help with the code
1. I want the column width size - column A =17 Column B = 30 Column C = 15 Column D = 12 Column E Auto Fit Column F = 25 Column G = 7 Column H = 10
2. If the page is more than 2 then Print Tiles - rows to repeat at top is 1st row A1 to H1.
3. And dark line Borders Inside and outside each cell where the Data available till the last row, I have data in all sheets from A to H.
Kindly help with the code