How to make a particular row in excel bold

Help Studio
3

@rifnanahas
as an alternate option to macro, with UiPath activities it can be done like following:

Select Range activity - here we can pass the range dynamic with a variable
Send Hotkey Activity - indicating to Excel with the selector

Hotkeys for bold:

  • CTRL+2
  • CTRL+B ( in some cases, depends on language / locals)
  • CTRL+SHIFT+F (local command e.g. for German, similar to the shortcut showing when hovering the Bold format Button in the ribbon menu)

Doing it with VBA / Macro:

  • using invoke VBA activity and pass the variable within the EntryMethodParameters
  • using execute Macro Activity and pass the variable within the MacroParameters
1 Like