Last cell display

  • Thread starter Thread starter Eddie Equihua
  • Start date Start date
E

Eddie Equihua

I need to display always the last row information on
another sheet in Excel
 
Hi,

Following code will help you.

Regards.


Haldun Alay

Function LastUsedRange(SheetName As String) As String
Application.Volatile True
Dim Wks As Worksheet
On Error Resume Next
Set Wks = Worksheets(SheetName)
If Err.Number <> 0 Then
Err.Clear
LastUsedRange = "Sheet not exist!"
End If
LastUsedRange = Wks.UsedRange.Address(rowabsolute:=False,
columnabsolute:=False)
End Function
 
Also...

For a text-valued column...

=LOOKUP(REPT("z",255),A:A)

would retrieve the last text value from A.

For a numeric column...

=LOOKUP(9.99999999999999E+307,A:A)

would retrieve the last numeric value (number, date, time) from A.
 
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

Help needed 0
Displaying a time value, conditionally. 1
Is this function supposed to work? 6
Displaying the current system time - 2nd Try 3
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
Excel Cannot delete empty cells/rows 4
Maybe too hard to do? 2
Referring to a variable cell on another sheet 5

Back
Top