Consulting

Results 1 to 3 of 3

Thread: Range and Selection question

  1. 12-09-2004, 08:36 AM #1
    JKwan
    JKwan is offline
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location

    Range and Selection question

    How do I find out how many Columns and Rows in a Selection (the dimension of that Range) in VBA?

    Thanks
    Reply With Quote Reply With Quote
  2. 12-09-2004, 08:49 AM #2
    Jacob Hilderbrand
    Jacob Hilderbrand is offline
    Site Admin
    Jedi Master         VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Selection.Rows.Count
Selection.Columns.Count



    Reply With Quote Reply With Quote
  3. 12-09-2004, 08:51 AM #3
    Jacob Hilderbrand
    Jacob Hilderbrand is offline
    Site Admin
    Jedi Master     VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Also if you want to know the first row/column:

    Selection(1, 1).Row
 Selection(1, 1).Column



    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