<div>
lastRowClass2 = &nbsp;Range(&quot;D1:D20&quot;).Row + Range(&quot;D1:D20&quot;).Rows.Count<wbr /> - 1
</div>


lastRowClass2 =  Range("D1:D20").Row + Range("D1:D20").Rows.Count - 1

<div>
But then again it's always 20 isn't it?
</div>


<div>
Sorry, I want to find the first blank and its corresponding row number in range &nbsp;D1:D20<br />
<br />
Thanks
</div>


Sorry, I want to find the first blank and its corresponding row number in range  D1:D20

Thanks

<div>
I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2015
</div>


I'm glad I was able to help.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am using the following to get the last row of a column:<br />
lastRowClass2 = ActiveSheet.Range(&quot;D&quot; &amp;&nbsp;Rows.Count).End(xlUp).Row<br />
<br />
I want to modify this a bit and find the last row only in a particular range such as D1:D20. I do not want to consider values that are beyond row 20.<br />
<br />
How can I do that?<br />
<br />
Thanks
</div>
</div>


Hi,

I am using the following to get the last row of a column:
lastRowClass2 = ActiveSheet.Range("D" & Rows.Count).End(xlUp).Row

I want to modify this a bit and find the last row only in a particular range such as D1:D20. I do not want to consider values that are beyond row 20.

How can I do that?

Thanks

last row

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

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.