Thread: Copy the formatting of one cell to other cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Subodh Subodh is offline
external usenet poster
  
Posts: 99
Default Copy the formatting of one cell to other cell
I have a cell in sheet1.
I want to copy the cell formatting to other cell in other sheet
Sheet2.
=Sheet1!A1 won't work as it will just copy the cells value but not
formatting.
How can i copy the formatting using the VBA Code?
Thanks in advance.
Reply With QuoteReply With Quote