<div>
Will the range always be B4:H4?
</div>


<div>
Thank you Andrew!<br />
<br />
I was about to give up and go get a drink. :)<br />
<br />
Also - thanks for taking this on a Sunday - you are awesome.<br />
<br />
Michael
</div>


Thank you Andrew!

I was about to give up and go get a drink. :)

Also - thanks for taking this on a Sunday - you are awesome.

Michael

<div>
<div class="content wysiwyg-content">
Ugh!!<br />
<br />
Hell Experts,<br />
<br />
I need help to find the last used cell column number in a set range.<br />
My range is &quot;B4:H4&quot;. &nbsp;As long as there is something in one of those cells - that is my column number I need.<br />
<br />
I have data in A4 &amp;&nbsp;I4 so I can not use the typical examples I found on-line.<br />
<br />
Once I find the column number - I can finish my code.<br />
<br />
Any assistance would be great,<br />
Thanks
</div>
</div>


Ugh!!

Hell Experts,

I need help to find the last used cell column number in a set range.
My range is "B4:H4".  As long as there is something in one of those cells - that is my column number I need.

I have data in A4 & I4 so I can not use the typical examples I found on-line.

Once I find the column number - I can finish my code.

Any assistance would be great,
Thanks

Excel VBA Find last column in range

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