Excel Format Cells Activity

Help Activities
1

I have a workbook with several sheets in it and all sheets have the same headers. The sheets are all written to excel from data tables and I have lost the formatting on some of them, such as currency.
The only formatting option I can find in excel activities with specific formatting type is “Format Cells”. Is it possible to just utilize this activity to format the entire column and not have to iterate through all the rows to format the cells in that column? Or is there possibly another option that might be more suitable?

2

Hi @mbuehler,

I suggest you to record the macro in excel, create a macro function which should contain above recorded macro vba code and create a text file which contains the above function. Invoke the above created function by using invoke vba activity by pointing to above created text file and function name in the activity properties. Then it will be working as you expected.

1 Like
3

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