| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format cells the same in two sheets
I have two sheets where I want cell B14 to B33 be formatted the same
way in both sheets regarding the border lines around each cell. The formatting can change in sheet A so I have to loop through each cell in sheet B to check how the same cell in sheet A is formatted and then set it accordingly. Can someone please help me? Regards, S |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format cells the same in two sheets
hi,
try using the format painter. regards, julian wrote: I have two sheets where I want cell B14 to B33 be formatted the same way in both sheets regarding the border lines around each cell. The formatting can change in sheet A so I have to loop through each cell in sheet B to check how the same cell in sheet A is formatted and then set it accordingly. Can someone please help me? Regards, S |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cells in 30 different sheets | Excel Discussion (Misc queries) | |||
| format 10 sheets on same file to look like first one | New Users to Excel | |||
| want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
| Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) | |||
| Format multiple sheets in VBA | Excel Programming | |||
Linear Mode
