Can you tell a cell to use the format of another cell
In otherwords, if a cell has a certain name entered in it, the cell would be instructed to go to a lookup table and find the name and then use its formats

and now a 3rd time!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"jlp" wrote in message
...
Can you tell a cell to use the format of another cell?
In otherwords, if a cell has a certain name entered in it, the cell would
be instructed to go to a lookup table and find the name and then use its
formats?

try this macro assigned to a button or shape to copy the formats of the cell
you specify to the active cell.

Sub copyformats()
Range(InputBox("Cell to copy")).Copy
ActiveCell.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone
Application.CutCopyMode = False
End Sub
--
Don Guillett
SalesAid Software

"jlp" wrote in message
...
Can you tell a cell to use the format of another cell?
In otherwords, if a cell has a certain name entered in it, the cell would
be instructed to go to a lookup table and find the name and then use its
formats?