Hi,
I am new to VBA programming and trying to write some code.
I wrote the following code.But when I run it, I get an error:
Compile Error:
Sub or function not defined
The highlighted code is: Run_Start
Could anyone tell me why? What have I done wrong or missed?Code:Sub Update_From_Local() Clock_Start RunAllfunction Clock_Stop End Sub Sub RunAll() 'Application.ScreenUpdating = False Run_Start PasteDown ("SalesOrders") PasteDown ("SupplyOrders") PasteDown ("Inventory") Stack ("DemandSupply") Sort3 ("DemandSupply"), ("RecordType"), ("ItemCode"), ("HARD_Date") PasteDownN ("DemandSupply"), 2 Sort2 ("DemandSupply"), ("ItemCode"), ("HARD_Cumulative") PasteDownN ("DemandSupply"), 3 Sort3 ("DemandSupply"), ("RecordType"), ("ItemCode"), ("FIFO_Date") PasteDownN ("DemandSupply"), 4 Sort2 ("DemandSupply"), ("ItemCode"), ("FIFO_Cumulative") PasteDownN ("DemandSupply"), 5 Run_Stop Sheets("Menu").Select 'Application.ScreenUpdating = True End Sub
Appreciate any help I can get, still learning this stuff.
Regards
Bill




Reply With Quote