Results 1 to 6 of 6

Amount of cells in a range

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2009
    Location
    Methylane
    MS-Off Ver
    Excel 2003
    Posts
    23

    Amount of cells in a range

    For starters, I'm stuck with merged cells, can't change it

    I need to come up with ways to work around this.
    Say I have a merged area of A1:A*, what I would like to know is how many columns are actually used in this merged area.
    A1:A4 would return 4, A1:A8 would return 8, A1:C8 would return 8 et cetera.

    Now I've played a bit with MergeArea.Address and although it returns me the correct range, I'm stuck with actually using it further.

    Any ideas?
    Last edited by ctor; 11-04-2009 at 08:47 AM. Reason: Solved :)

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