include the data purge for Engineer Gantt and Tech Gantt similar to Location Gantt

DJimmie / JS_Program

Scheduling program in Excel VBA. To be replaced by the Python version in the near future.

0 stars 0 forks source link

Closed DJimmie closed 5 years ago

DJimmie commented 5 years ago

include the data purge for Engineer Gantt and Tech Gantt similar to Location Gantt:

in the Sub SQL_data_to_Gantts()
code simular to what is used for the Location Gantt: Sheets("Location Gantt").Activate lastRow = Sheets("Location Gantt").Application.WorksheetFunction.CountA(Range("A:A")) Sheets("Location Gantt").Range(Cells(2, 1), Cells(lastRow, 9)).Select Selection.ClearContents