Results 1 to 1 of 1

Thread: Finding Last Used Row or Column In Excel Sheet

  1. 04-14-2011, 03:17 AM #1
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Finding Last Used Row or Column In Excel Sheet

    This is for the entire sheet - so ALL rows - ALL columns

    Code:
    With ActiveSheet.UsedRange
      LastRow = .Rows(.Rows.Count).Row
      ColLast = .Columns(.Columns.Count).Column
End With
    Last edited by Rasm; 04-14-2011 at 03:18 AM. Reason: typo
    xl2007 - Windows 7
    xl hates the 255 number
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Highlight Active Cell’s Row and Column
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  2. Column to Row and Row to Column
    By lokvan in forum Excel Help
    Replies: 1
    Last Post: 11-30-2012, 09:30 AM
  3. Copy Row To A New Sheet If A Value Found In Adjacent Column
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-17-2012, 05:42 PM
  4. Find Last Used Row In Column
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 06-04-2012, 07:40 AM
  5. Find The Last Entry Row In A Column That Contains Only Numbers
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 05-09-2011, 05:19 AM

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
  •  

Forum Rules