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?
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?

Any help would be appreciated, thanx
Last edited: