Last record

  • Thread starter Thread starter bijan
  • Start date Start date
B

bijan

Hi all,
I connect to a database and receive data, my data is sorted and therefor the
maximum date must be in the last record
1.How can I capture the maximum date that exist in column E ?
2. and how can I put this value in "F10"(at the beginig of the file) and
auto fill it to the end of the file?
Thanks in advance
Bijan
 
Hi,

If column A is dates you don't need to specifically find the last row you
can get the latest date with

Dim Mydate As Date
Range("F10") = WorksheetFunction.Max(Range("A:A"))

If you want to find the value from the last row you can use

lastrow = Cells(Rows.Count, "A").End(xlUp).Row
Range("F10") = Range("A" & lastrow).Value

Mike
 
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

vba solution 8
Predict Next Date 7
Marking found records in Workbook A from Target List in Workbook B 1
Search and Replace via VBA 3
Compare data set 1 with data set 2. Add to data set 2 if not found 0
Need Excel Macro to select an unknown, named table and convert it toa range 1
Advanced filter on last months results 6
modified date of the file 3

Back
Top