Thread: Excel vba

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    2
    Rep Power
    0

    Excel vba


    I am new to vba / macros in excel. Is there a way I can determine the very last cell used on a spreadsheet ?

    Thanks

    Dave
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    Romsey, hampshire, England
    Posts
    2
    Rep Power
    0
    You might like to look at SpecialCells(xlCellTypeLastCell). Check it out on the internet.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    2
    Rep Power
    0
    Thanks, I have found it, and it does what I want.

IMN logo majestic logo threadwatch logo seochat tools logo