Excel VBA to Find the last row with data in a given Column

It is for Excel programming like Macro, function, formula, Pivot and other platform support..
alpeshviranik
Posts: 81
Joined: Thu Jul 17, 2014 4:58 pm
Contact:

Excel VBA to Find the last row with data in a given Column

Postby alpeshviranik » Wed Jul 30, 2014 5:45 pm

How can I find the last row using VBA Code that contains data in a specific column?


Guest

Re: Excel VBA to Find the last row with data in a given Colu

Postby Guest » Wed Jul 30, 2014 10:00 pm

You can get last row which have data in column C. You can use below VBA code to get last row which have data for column C.

Code: Select all

Dim LastDataRowsC As Long
LastDataRowsC = ActiveSheet.Cells(rows.count, "C").End(xlUp).row


Return to “Microsoft Excel and VBA Forum”

Who is online

Users browsing this forum: No registered users and 2 guests