Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-execute all UDF programmatically
Try:
Sub macx() Dim w As Worksheet For Each w In ActiveWorkbook.Worksheets w.Activate ActiveSheet.Calculate Next w End Sub -- Gary''s Student "Peter" wrote: Hi, I'd like to know how I can loop through all Formula / UDF in all worksheets in a workbook programmatically? Do SpecialCells be useful here? Do the returned Ranged (by SpecialCells) contains multiple range? TIA. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
execute once formula | Excel Programming | |||
Could not execute | Excel Worksheet Functions | |||
VBA new function doesn't execute | Excel Programming | |||
tried to execute application from VBA | Excel Programming | |||
tried to execute application from VBA | Excel Programming |