currentregion property in vba

[learning_grexcel]

I have only one column i.e. A with some values and I wanted to select the column using currentregion property.

I tried the code below, but it could not select anything. Is there any mistake?

Range("A1").currentregion.select


Of course, I know the other way to select is using code "Range("A:A").select" but I'm trying to learn currentregion property.

 

[patel45]

Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. Read-only.
it works on my test sheet

 

[Michael M]

Is there anything in A1 and B1 ??
You could also try

Sub MM3()
ActiveCell.CurrentRegion.Select
End Sub

 

[Michael M]

Is there anything in A1 and B1 ??
You could also try

Sub MM3()
ActiveCell.CurrentRegion.Select
End Sub

 

[learning_grexcel]

Is there anything in A1 and B1 ??
You could also try

Sub MM3()
ActiveCell.CurrentRegion.Select
End Sub

This code also doesn't work. Yes I have values in A1.

 

[Michael M]

OK, but remember....CurrentRegion is an area bounded by blanks.
So, if A1 has data and B1 AND C1 are blank A1 will be the currentregion