+ Reply to Thread
Results 1 to 6 of 6

trying to count the circleinvalid in a range w msg box, getting error 483

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    ohio
    MS-Off Ver
    Excel 2010
    Posts
    4

    trying to count the circleinvalid in a range w msg box, getting error 483

    Dim instance As Ovals
    Dim i As Integer
    Dim rng As Range
    Set rng = Range("G5:G2000")
    i = rng.instance.Count
    MsgBox ("You have " & i & " errors")

    End Sub

    I am trying to put this at the end of a sub that is working. I get a run-time error 438 on the line "i = rng.instance.Count". Can anyone please tell me what I am doing wrong? I know just enough VBA to be dangerous .

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: trying to count the circleinvalid in a range w msg box, getting error 483

    AFAIK, instance is not a property of a Range object. What are you trying to do?

    Just a wild guess but

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: trying to count the circleinvalid in a range w msg box, getting error 483

    a range doesn't have an Ovals property-and you couldn't refer to it that way if it did. nor can you count invalid cells that way because the circles are not part of the shapes collection of the sheet. are you trying to count the number of cells failing data validation in that range?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Registered User
    Join Date
    04-11-2013
    Location
    ohio
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: trying to count the circleinvalid in a range w msg box, getting error 483

    Yes, I am trying to count the invalid cells and have a message box pop up with the number of errors. I appreciate all the help.

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: trying to count the circleinvalid in a range w msg box, getting error 483

    perhaps
    Please Login or Register  to view this content.
    then in the calling code
    Please Login or Register  to view this content.

  6. #6
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: trying to count the circleinvalid in a range w msg box, getting error 483

    You should adjust the range in Test to suit your needs.

    Please Login or Register  to view this content.
    Last edited by mikerickson; 07-17-2013 at 01:32 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error rsh = Sheets(st).Range("A" & Rows.Count).End(xlUp).Row + 1
    By Jocatlett in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-12-2013, 10:52 AM
  2. [SOLVED] Count in a range, where identical adjacent cells count as one instance.
    By the-algebraist in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-05-2013, 11:18 AM
  3. Replies: 7
    Last Post: 04-22-2011, 10:42 AM
  4. Rows.Count error in dynamic range naming
    By Andrew-Mark in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-07-2010, 03:27 AM
  5. Range.columns.count property returns wrong count after union operation
    By gopinan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2008, 04:48 AM

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