+ Reply to Thread
Results 1 to 4 of 4

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

  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

    Please Login or Register  to view this content.

  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 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:
    Please Login or Register  to view this content.
    • 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

  4. #4
    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.

+ 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