sellecting all table

[Awesome77]

Hi to all,

hope you are well

I have just entered the VBA world, and I would like your support regarding the below code in which VBA is not accepting it

range("A3", range("A1").End(xlDown)).Select

please note that I'm using excel 2016

thanks a lot in advance

 

[Fluff]

Hi & welcome to MrExcel.
In what way isn't that code working?

 

[MARK858]

Just to add to Fluff's question, What result were you expecting? and what does your data look like?

 

[Awesome77]

Hi Fluff & Mark

happy to be here with such wonderful people..

Actually, I'm trying to write a code where I select all the table from the start to the all the way to the end..

e.g range starts with A1 and ends with c3

thanks a lot

 

[MARK858]

Range("A1:C" & Columns("A:C").Find("*", , xlValues, , xlByRows, xlPrevious).Row).Select

 

[My Aswer Is This]

Assuming your Table is name Table1
Try this:

Sub Select_Table()
'Modified  8/19/2018  10:46:45 PM  EDT
ActiveSheet.ListObjects("Table1").Range.Select
End Sub

 

[mikerickson]

OR

Range("A1").CurrentRegion.Select

 

[Fluff]

Another option

ActiveSheet.UsedRange.Select