As I learned here (also quoted in SO) the following code can be used to select the data-body of column 3 in Table1
:
ActiveSheet.ListObjects("Table1").ListColumns(3).DataBodyRange.Select
I need help to select a number of columns together - say columns 3 to 5, or columns X to X+3 .
Using answers to this question I manged to go halfway by using actual column names:
Range("Table1[[Column3]:[Column5]]").Select
But I need to be able to use column numbers instead of names, as they will be the result of a function (i.e. columns X to X+d).
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With