View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre Laporte Pierre Laporte is offline
external usenet poster
 
Posts: 7
Default to modify cells from a function

When I use the following code from a macro call on the menu of Excel it
works fine (changes the format of the top leftmost cells of the sheet but
when I execute it from a function that is used in a cell of the sheet it
does not work.
How can I change the format or content of cells in a spreadsheet from within
a vusual basic function called in a cell ?
_______________________________________________

Sub upc()

Dim myCell As Range
Set myCell = Worksheets("Feuil1").Range("A1:C1")
With myCell.Font
.Bold = True
.Italic = True
End With

End Sub