<div>
Hi matthews_30,<br />
try this:<br />
<br />
Range(&quot;C65536&quot;).End(xlUp).<wbr />Address(0,<wbr /> 0)<br />
<br />
Rajesh
</div>


Hi matthews_30,
try this:

Range("C65536").End(xlUp).Address(0, 0)

Rajesh

<div>
ActiveSheet.Range(&quot;a1&quot;).Sp<wbr />ecialCells<wbr />(xlCellTyp<wbr />eLastCell)<wbr />.Column ' last cell on a column<br />
ActiveSheet.Range(&quot;c1&quot;).Sp<wbr />ecialCells<wbr />(xlCellTyp<wbr />eLastCell)<wbr />.Row &nbsp;' last cell on c row
</div>


ActiveSheet.Range("a1").SpecialCells(xlCellTypeLastCell).Column ' last cell on a column
ActiveSheet.Range("c1").SpecialCells(xlCellTypeLastCell).Row  ' last cell on c row

<div>
<div class="content wysiwyg-content">
i have an spreadsheet that has 3 columns and the data in every field is populated every month, so always the amount of data may varies.<br />
<br />
for example, some months i can have from cell a1 to cell c32, and in other months i can have from cell a1 to cell c43<br />
<br />
i need to know the final cell, in this example, c43.<br />
<br />
additional.<br />
<br />
i always have 3 columns, A, B and C.<br />
<br />
thanks a lot.<br />
<br />
matt
</div>
</div>


i have an spreadsheet that has 3 columns and the data in every field is populated every month, so always the amount of data may varies.

for example, some months i can have from cell a1 to cell c32, and in other months i can have from cell a1 to cell c43

i need to know the final cell, in this example, c43.

additional.

i always have 3 columns, A, B and C.

thanks a lot.

matt

in VB how to know the last record of an excel spreadsheet?

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.