+ Reply to Thread
Results 1 to 4 of 4

Run time error '438': Object doesn't support this property or method

Hybrid View

baig123 Run time error '438': Object... 06-27-2014, 03:04 AM
adyteo Re: Run time error '438': ... 06-27-2014, 03:59 AM
baig123 Re: Run time error '438': ... 06-27-2014, 04:59 AM
Izandol Re: Run time error '438': ... 06-27-2014, 04:39 AM
  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Run time error '438': Object doesn't support this property or method

    Sub repla()
        Dim LR As Long
        Dim Dash As Long, _
            Whole As Double
        Dim pi
        Sheets("Sheet3").Range ("A" & Rows.Count)   -->getting error here
     
        For r = 2 To LR
          s = Cells(r, 3)
          arr = Split(s, ",")
          For i = LBound(arr) To UBound(arr) 
            Whole = 0
            P = InStr(arr(i), " IN")
            Frac = Left(arr(i), P - 1)
            Dash = InStr(Frac, "-")
            If Dash > 0 Then
                Whole = Left(Frac, Dash - 1)
                Frac = Mid(Frac, Dash + 1, Len(Frac))
            End If
            af = Right(arr(i), Len(arr(i)) - P + 1)
            evfrac = Whole + Left(CStr(Evaluate(Frac)), 5)
         '   evfrac = Whole + Format(Evaluate(frac), "0.###")
            ss = ss & evfrac & af & ", "
          Next i
          Cells(r, 4) = Left(ss, Len(ss) - 2)
          ss = ""
        Next r
    End Sub

  2. #2
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Run time error '438': Object doesn't support this property or method

    what are you trying to achieve with: Sheets("Sheet3").Range ("A" & Rows.Count)???
    secondly, you have to declare a lot of other variables there. you would need to clean up your code. I suggest you use "Option Explicit" for all your VBA
    Click on the star if you think I helped you

  3. #3
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: Run time error '438': Object doesn't support this property or method

    in my sheet3 having fractional values i am trying to convert them to decimal using this code

    please help me out i am bit confused here
    Last edited by baig123; 06-27-2014 at 05:59 AM.

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Run time error '438': Object doesn't support this property or method

    I believe you miss some words:
    LR = Sheets("Sheet3").Range("A" & Rows.Count).End(xlUp).Row
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

+ 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. Run-time error '438': Object doesn't support this property or method
    By s3a in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 11-15-2012, 11:25 AM
  2. Run-time error '438': Object doesn't support this property or method
    By ThaGreenMoose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2011, 01:17 PM
  3. Run-time error '438' Object doesn't support this property or method
    By Lothar69 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2011, 03:30 PM
  4. Run-Time Error '438' - Object doesn't support this property or method
    By rajibyumnam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2011, 03:24 AM
  5. Run-time error '438': Object doesn't support this property or method
    By ophelia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2007, 05:27 AM

Tags for this Thread

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