Format Cells in Invoke Code

Hi Everyone,

How to change the syle of the excel in invoke code.

Eg : Change bg Color,Font,Size of the cell.

Regards
Saran S R

SetRangeColor activity can be used for changing color.
While for font etc, can try macros and use execute macro activity

Hi

you can use macros to change the colour and font of the selected Range.

I am attaching an example macro which you can take it as reference , I am selecting the particular range and changing its format and colour.

VBAForDateChangeInSelected.txt (723 Bytes)

1 Like

Thanks @vishnuvarthanp

In our organization macro is not Recommendable.

1 Like

Thanks again @vishnuvarthanp and @ArunVelaayudhanG

Found the solution using invoke activity.

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.