Hello All,

I need to set the range of the column till the last value in the columns starting from A9, current i have tried it out with the below statement, How to replace the last value with a common statement

Dim S_Range As Range
Set S_R = S_Data.Sheet.Range("A9:A565")

Any suggestions, Thanks in advance.