Thread: Format cells the same in two sheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] staeri@gmail.com is offline
external usenet poster
  
Posts: 35
Default Format cells the same in two sheets
How can I do that with VBA?

Regards,

S

skrev:

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 With QuoteReply With Quote