<div>
I wasn't expecting the answer to be so simple and common sense logical. Thanks, Patrick. <br />
<br />
And thanks Thomas for a way to approach it when there's no pre-defined range to play off of.<br />
<br />
- John
</div>


I wasn't expecting the answer to be so simple and common sense logical. Thanks, Patrick.

And thanks Thomas for a way to approach it when there's no pre-defined range to play off of.

- John

<div>
Glad to help. &nbsp;BTW, if you always want the last column, but are not sure which column number that would be...<br />
<br />

<pre><code id="code-20-36318126-1">With Range(&quot;Table1&quot;)
    Set MyLastColumn = .Columns(.Columns.Count)
End With</code></pre>
</div>


Glad to help.  BTW, if you always want the last column, but are not sure which column number that would be...



With Range("Table1")
    Set MyLastColumn = .Columns(.Columns.Count)
End With

<div>
Glad to see you're making progress on the VBA front, John. <br />
<br />
Thomas
</div>


Glad to see you're making progress on the VBA front, John.

Thomas

<div>
<div class="content wysiwyg-content">
This range definition (LastCol) gives me the last column of my 11-column wide Table1:<br />
<br />
=OFFSET(Table1,0,10,ROWS(T<wbr />able1),COL<wbr />UMNS(Table<wbr />1)-10)<br />
<br />
How do I express that in VBA so that I don't have to create and name the range before running a macro that relies on it?<br />
<br />
Thanks,<br />
John
</div>
</div>


This range definition (LastCol) gives me the last column of my 11-column wide Table1:

=OFFSET(Table1,0,10,ROWS(Table1),COLUMNS(Table1)-10)

How do I express that in VBA so that I don't have to create and name the range before running a macro that relies on it?

Thanks,
John

Excel VBA equivalent of a range definition

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.