Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
to modify cells from a function
You can't. That is not allowed by Excel.
A function used in a cell can only return a value to the cell - it can't change the "environment". http://support.microsoft.com/default...b;en-us;170787 XL: Custom Functions Can't Change Microsoft Excel Environment Regards, Tom Ogilvy "Pierre Laporte" wrote in message .. . 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify search function | Excel Worksheet Functions | |||
Modify array function length | Excel Worksheet Functions | |||
Is there a way to modify the DAYS360 function to accomadate a 365 | Excel Worksheet Functions | |||
How do I modify the autofit function in Excel? | Excel Discussion (Misc queries) | |||
Can I modify a Hyperlink with a function? | Excel Discussion (Misc queries) |