Job title: Supply Chain Data Analyst Company: Darigold Job description: Description : The Supply Chain Data Analyst role is responsible for providing data mining, cleansing, and reporting support to various functions across the entire Supply Chain organization. With an enhanced focus on continuous improvement, this role leads the charge on enabling data driven storytelling, process…
Sub HighlightCommentedCells() ActiveSheet.Select Selection.SpecialCells(xlCellTypeComments).Select Selection.Style = “Note” End Sub
Sub SortSheetbyName() Application.ScreenUpdating = False Dim ShCount As Integer, i As Integer, j As Integer ShCount = Sheets.Count For i = 1 To ShCount – 1 For j = i + 1 To ShCount If Sheets(j).Name < Sheets(i).Name Then Sheets(j).Move before:=Sheets(i) End If Next j Next i Application.ScreenUpdating = True MsgBox “All sheets sorted!” End…
Sub Enable_Edit() If Application.ProtectedViewWindows.Count > 0 Then Application.ActiveProtectedViewWindow.Edit End If End sub
