Seting a range to where there only data

[balistikb]

I am trying to modify a macro with VB and I need to be able to select a range where ther is only data. What I have now is this Range("A2:H9").Select. I know this just selects what I have put as a range. How to I just select a range where there is data only. The range may grow or shrink depending on how much information I have in my sheet.

 

[dyarwood]

Try

x = Cells.SpecialCells(xlCellTypeLastCell).Row
y = Cells.SpecialCells(xlCellTypeLastCell).Column

Range(Cells(1, 1), Cells(x, y)).Select

 

[balistikb]

Do I actualy type (xlCellTypeLastCell) or am I supposed to enter something in there?

 

[dyarwood]

sorry that was in the vba behind excel

 

[dyarwood]

If you just copy what I have but you will get a selection from A1 to the last cell you have used.

 

[balistikb]

This did work thanks.
Now I am trying to figure out how to group and then select that range. All in VB behind excel.

 

[dyarwood]

How do you mean group?