Width & Merge Cells [Solved/Closed]

Report
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
Hello,
I Have 1 WorkSheet In Which There Are Too Many Sub Sheets.

I Want The Width & Merge Cells Of Sheet1 In To All Sheets. But I Dont Need The Data Of Sheet1.

Need Macro Code..........


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
Dude, again what you want ? do you have sample book. that you can upload to some share site
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
Delete Macro 10
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
Using Of Macro1 : I Just Wanna Explain You That Before Running Macro1 Look At My Sheet1 Careful. Because When You Run Macro1 My Code Change It..

I Want The Same Alignment Including Merge Cells Of Sheet1. Each & Everything Of That Sheet To Other Sheets Which Will Auto Create When You Run Macro1...........
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
Hey Rizvisa I Almost Done It...... But After Running Macro 10 It Merge A1 To J1

Same As I Want To Merge A2 To J2 To All Sheets

For A2 To J2 Do I Make A New Macro ? Or You Can Help Me To Joint Multiple......
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
I must be missing some thing here. Why you cannot add few more lines to merge A2:J2 as you did for A1:j1?
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
Done Dude :)

Thx :)