+ Reply to Thread
Results 1 to 2 of 2

Version Incompatibility

  1. #1
    JUnk
    Guest

    Version Incompatibility

    I have a simple workbook with some code which includes the lines:

    colb = Range("B:B")
    nrows = Application.CountA(colb)

    This has always been run under Excel 2003 where it works fine. However today
    we ran the same code on Excel 2000 and the second line produces a type
    mismatch error. Can anyone shed some light on this and provide an
    alternative which will work under all versions?

    Thanks

    Ted



  2. #2
    Bob Phillips
    Guest

    Re: Version Incompatibility

    I am surprised it worked in 2003. Try

    Set colb = Range("B:B")


    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "JUnk" <junk@educator.com.au> wrote in message
    news:ePoIe.71861$oJ.46560@news-server.bigpond.net.au...
    > I have a simple workbook with some code which includes the lines:
    >
    > colb = Range("B:B")
    > nrows = Application.CountA(colb)
    >
    > This has always been run under Excel 2003 where it works fine. However

    today
    > we ran the same code on Excel 2000 and the second line produces a type
    > mismatch error. Can anyone shed some light on this and provide an
    > alternative which will work under all versions?
    >
    > Thanks
    >
    > Ted
    >
    >




+ Reply to Thread

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