Finding and setting first row and column and last row and column: VBA Excel

Sub SetRowsColumns()
Dim nSpecificColumn, nRowFirst, nRowlast, nColFirst, nColLast as integer

    nSpecificColumn = 2

    nRowFirst = oDataSheet.Cells(1, 1).End(xlDown).Row 'Finds and sets the first used row
    
    nrowlast = oDataSheet.Cells(nRowFirst, nSpecificColumn).End(xlDown).Row 'finds and sets the last used row in a specified column
    
    nColFirst = oDataSheet.Cells(nRowFirst - 1, 1).End(xlToRight).Column 'finds and sets first used column
    
    nColLast = oDataSheet.Cells(nRowFirst - 1, nColFirst).End(xlToRight).Column 'finds and sets the last column
    
End Sub

Comments

[wjx]

Mbt zapatosunder Cuando el trueno le gustaría hay necesidad de buscar tanto miedo Lonely gustarí¿Dóndeestás Mbt zapatosunder. ahoraCuando se quiere esperar ¿Cómo su cuerpo sin alas Cuandovaaquerer volver a casaEn la piscina de ustedes no hanSiempre se ríen dmítonNo reconocer su propio cabelloNo entiendo cómo loHa Mbt zapatosno estado trabajando como locos parapensar en pensar de la mañana a la nocheMiedo se podría pensarTrabajo como un loco para pensaren pensarPensando en ti locoTengo Quieres a morder los dientes blancos Trabajo como un loco para pensar que cree que pensar en elMbt zapatosamanecer。

[cheap software]

<a href="http://www.onlinecheapsoftware.com/">application software</a>

<a href="http://www.onlinecheapsoftware.com/">system software</a>

<a href="http://www.onlinecheapsoftware.com/">cheap software</a>

<a href="http://www.onlinecheapsoftware.com/">oem software</a>

<a href="http://www.onlinecheapsoftware.com/cheap-Application-Software/Adobe-Creative-Suite-CS5-5-Design-Premium">Adobe Creative Suite CS5.5 Design Premium</a>

[Formal Dresses]

Thank for your time to share us this discuss, i have some opinion on the <a href="http://www.dressaler.com/" title="Formal Dresses">Formal Dresses</a>, I feel so stronl about your article, and learning more on this topic, then it is so good, Do you have time visit us <a href="http://www.dressaler.com/wedding-party-dress/bridesmaid-dresses.html" title="Wedding Bridesmaid Dresses">Wedding Bridesmaid Dresses</a>.I will bookmark your blog and have my kids check up here frequently <a href="http://www.dressaler.com/wedding-party-dress/junior-bridesmaid-dresses.html" title="Junior Bridesmaid Dresses">Junior Bridesmaid Dresses</a>. I’m very certain they will understand lots of new stuff here than anybody else. I do appreciate that youve added relevant and intelligent commentary here though. Thank you!