Hi I have the following lines of code
Sub selection()
'Dim ws As Worksheet
Dim rng As Range
'
Set rng = Range("A2").CurrentRegion
'rng.Delete
rng.Select
End SubIt selects me all the cells that have information in that region, including the row of A1, but I don't want the first row to be selected, is there a way I can indicate to CurrentRegion that it should select all from A2 to all the cells that have information. And no I cannot specify a range because the information that is given in the cells I want to select is variable so it's not always the same length. Any thoughts?
2 Answers
Sub selection() Dim rng As Range Set rng = Range("A1").CurrentRegion rng.Offset(1, 0).Resize(rng.Rows.Count - 1, rng.Columns.Count).Select
End Sub 0 Is it possible to select current region without first column too?
I was trying:
rng.Offset(1, 0).Resize(rng.Rows.Count - 1, rng.Columns.Count - 1).Selectbut then, the last col is dropped, not the first one.
0