select a variable range

[triegaardtm]

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

 

[dmt32]

try this:

With Worksheets("Sheet1")
.Range(.Cells(1, "A"), .Cells(.Cells(.Rows.Count, "A").End(xlUp).Row, "A")).Select
End With

Dave

 

[Leandrial]

Or if yo uonly have that range of cells in sheet

activesheet.usedrange.select

Thats a quick, dirty way to select the range, but very usefull from time to time


Best regards

 

[triegaardtm]

Thank you, works wonders