View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
papero papero is offline
external usenet poster
 
Posts: 1
Default function formatting a cell

Suppose I have a value in A1 and the formula
=FormatCell(A1), calling the following macro, in B1

Function FormatCell(a As Range)
a.Cells(1, 1).Select
Selection.Font.Bold = True
Selection.Font.ColorIndex = 3
End Function

Why I hav'nt A1 formatted?
I have breakpointed the macro and it triggers when I change the A1
value.

Bye, Emiliano