triegaardtm
New Member
- Joined
- Nov 29, 2012
- Messages
- 30
Hi
I'm a beginner!
I need to select a range of cells (that changes) with data using VBA.
I know to select the last cell containing text to use:
Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Select
But what do I do to select a whole range?![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
Any help would be appreciated, thanx
I'm a beginner!
I need to select a range of cells (that changes) with data using VBA.
I know to select the last cell containing text to use:
Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Select
But what do I do to select a whole range?
![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
Any help would be appreciated, thanx
Last edited: