Results 1 to 14 of 14

Sum Lastrow formula!!

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    259

    Sum Lastrow formula!!

    Hi, I'm not sure where I'm going wrong with this formula? I cannot specify a worksheet as they vary. Thanks

    Sub Sum_Last_Row()
    
    Set Lastrow = Cells(Rows.Count, "C").End(xlUp).Offset(1, 0)
     
    Lastrow = WorksheetFunction.Sum("C7, Lastrow -1")
     
     End Sub
    Last edited by Hurricanefly; 05-17-2013 at 11:57 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1