I used the following
The following Range("Sheet1!A2:A" & Rows.Count) To define a range from the first cell to the last cell.
The problem is that Row.Count don't take the LastUsedRange of the specific Range.
How should I define my Range by keeping the same strcture Range("Sheet1!A1:A" & Row.Count (but row.Count of the specific column)
Thank you very much.