Re: find the last row number

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 16:24:08 +0200

Hi
try something like
LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row 

--
Regards
Frank Kabel
Frankfurt, Germany
Newbie wrote:
> Hi,
>
> I have some code that imports a text file into a template.  In colums
> F-I there are some formulaes that I need to copy down to the last row
> of the imported text file.  The last row can change everytime the
> file is imported.
>
> How can I find which row is the last row and then copy the formulaes
> down?

Relevant Pages

  • find the last row number
    ... I have some code that imports a text file into a template. ... In colums F-I ... How can I find which row is the last row and then copy the formulaes down? ...
    (microsoft.public.excel.programming)
  • Re: A question about closing the SqlDataReader
    ... I am a newbie and using VB.Net. ... equivalent to Imports. ... I know read in the online help that it also can ... >using (SqlDataReader reader = cmd.ExecuteReader()) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with Java servlet : getServletContext().
    ... > I am newbie to Java, am trying to get a program working, and I have ... > imported the java packages below along with many other imports: ...
    (comp.lang.java.help)
  • Pause between Macros
    ... I'm running a macro that imports ... I need to know how to keep the next macro from running until this ... If you have a VB answer, please write you suggestion ... where a newbie like me can understand. ...
    (microsoft.public.access.macros)