For a Limited Period!
Buy 2 ~ Free 1 pax OR Get 30% off for every pax on our scheduled classes
for the month of Jan, Feb, Mar, Apr 2022
Analyzing Data with Power BI
Microsoft Excel - Power Query (M365, 2021-2010)
Microsoft Excel - Power Pivot (M365, 2021-2010)
Sometimes we need to know what the cell contains ie dates, text or formulas before taking a course of action. In this example a message box is displayed. Replace this with a macro should you require another course of action.
If Application.IsText(ActiveCell) = True Then
MsgBox "Text" 'replace this line with your macro
If ActiveCell = "" Then
MsgBox "Blank cell" 'replace this line with your macro
If ActiveCell.HasFormula Then
MsgBox "formula" 'replace this line with your macro
If IsDate(ActiveCell.Value) = True Then
MsgBox "date" 'replace this line with your macro