Suggest a method for this
is this activity will it change the full column of the excel??
Yes, we can specify the range for it
Hi @Gopikrishna_S
something like this
you can mention the range
Sub FormatColumn()
Sheet1.Range(“C2”, “C50000”).NumberFormat = “0.00”
End Sub
use above code in invoke VBA activity.
Here C is the column I want to do formatting. You can change this as per your need.
Entry point will be FormatColumn instead of Main.
If this is useful, mark this as solved.