Advanced excel operations in Power Automate | LazyBots

 

In this tutorial,

we are covering advanced excel actions available in power automate desktop

Actions covered are:

• Run Macro
• Add/delete worksheets
• Add/delete columns
• Add/delete rows
• Copy and paste cells
• Select cells in an excel

The macro used in the is given below,

Sub SetMessage()

'

' SetMessage Macro

'

' Keyboard Shortcut: Ctrl+Shift+M

'

    Range("D2").Select

    ActiveCell.FormulaR1C1 = "Success"

    Selection.AutoFill Destination:=Range("D2:D6")

    Range("D2:D6").Select

End Sub