Format A2 to First Free Row

Help StudioX
1

Hi Guys,

Looking to format Column A from A2 to First_Free_Row.

Below are not working, thanks guys :grinning:

Excel.Sheet(“Sheet1”).Range(“A2”+(First_Free_Row).ToString)
Excel.Sheet(“Sheet1”).Range(“A2”+First_Free_Row.ToString)

2

try
Excel.Sheet("Sheet1").Range("A2:A"+First_Free_Row.ToString)

1 Like
3

Perfecto !!! :grinning:

Many thanks buddy !

1 Like
4

Slight adjustment if it helps anyone in future, place -1 after first free row.
Thanks again.

Excel.Sheet(“Sheet1”).Range(“A2:A”+(First_Free_Row-1).ToString)

1 Like
5

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