How to add borders to an excel with unknown number of rows

[rifnanahas (rifna)]

I have multiple number of excel sheet in an excel file with count( int variable) number of rows. how can I add borders to that excel sheets…
Can anyone help me answer…

[samir (Samir Mohite)]

Hi @rifnanahas,

I’ll suggest you to record a macro in excel by applying borders, store VBA code in .txt file and using Invoke VBA activity (and mention that method name in activity) in Excel Application Scope you can run that macro for the same excel.

@rifnanahas

with count( int variable) number of rows. how can I add borders to that excel sheets…

To make that macro dynamic (for no of rows), you can pass any argument to the method in the “Entry Method Parameters” (to make range dynamic)

To make range dynamic in VBA code you’ve to make following changes,

That’s it