Results 1 to 2 of 2

Thread: Rows Filled in Excel

  1. Jul 25th, 2002, 03:36 PM #1
    svskumar
    svskumar is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Posts
    76

    Rows Filled in Excel

    How to get the filled rows in a excel worksheet

    I have worksheet i neeed to programatically Thru a macro get the last row col combination entered.
    Reply With Quote Reply With Quote
  2. Jul 26th, 2002, 06:34 PM #2
    svskumar
    svskumar is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Posts
    76

    Found a solution

    Here is how you can find the range for a excel work sheet

    MsgBox ActiveCell.CurrentRegion.Row
    MsgBox ActiveCell.CurrentRegion.Column

    MsgBox ActiveCell.CurrentRegion.Rows.Count
    MsgBox ActiveCell.CurrentRegion.Columns.Count


    Thank you
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width