Enter a cell value from a VBA macro

  • Thread starter Thread starter lo032398
  • Start date Start date
L

lo032398

I have a macro which works out the last row in a column of data. I wan
to put the row number in a Cell. How can I do this ?

Thank
 
Hi

Following macro puts the last row number of the Range
starting in A1 in cell B1.

regards


Sub Macro11()

Dim lLastRow As Long
Dim rgLast As Range

Set rgLast = Range("A1").SpecialCells(xlCellTypeLastCell)
lLastRow = rgLast.Row

Range("A1").Value = lLastRow

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA set thick borders around non empty cells in range 0
VBA CreateNames (ignores last 5 rows?) 6
Named cells in an array to a column and to a row 3
Run Macro If Cell have "x" value 0
Excel VBA 1
Macro storing as a date? 11
Macro to Combine Data from Multiple Sheets with Cell References 4

Back
Top