I am trying to copy values from sheet1 to sheet2. The number of rows of sheet1 varies so I need to store it in a variable. I need something like:

```
Worksheets("Sheet1").Range("A2:Ab").Select

```

, where "b" is a variable that stores the number of rows in Sheet1.

Thank you.