MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking formats


Posted by Diana on January 04, 2002 12:36 PM

Hello,
Is it possible to have a cell in one worksheet link to another, but link the format not just the value?

Thank you!


Posted by Ken on January 04, 2002 2:56 PM

Hi Diana,

If you paste the contents of the following macro within the Sheet2 Worksheet Activate, this will copy cell A1 from Sheet1 to cell A1 Sheet2. Obviously adjust the cell range to the ranges you need. To paste macro. Right click Sheet2, select "View Code", within Visual Basic window are two dropdown boxes. On the left dropdown box select Worksheet Activate, copy and paste the contents of the following macro.

Application.EnableEvents = False
Sheets("Sheet1").Range("A1").Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Application.EnableEvents = True


Ken