+ Reply to Thread
Results 1 to 2 of 2

Division in code produces a zero value when it shouldnt

  1. 06-11-2020, 05:15 PM #1
    welchs101
    welchs101 is offline
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,666

    Division in code produces a zero value when it shouldnt

    hi, i am doing something wrong.

    i have the following code and it keeps returning a value of zero

    Please Login or Register  to view this content.
    what am i doing wrong
    Reply With QuoteRegister To Reply
  2. 06-11-2020, 05:28 PM #2
    nankw83
    nankw83 is offline
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Division in code produces a zero value when it shouldnt

    Long data type doesn't accept decimals, try change it to Double
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro now produces an error code.
    By Funky Gibbon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2018, 04:15 PM
  2. Stepping through code produces different result than running code
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2015, 08:27 AM
  3. [SOLVED] Excel produces Error when the code works
    By WadeLair in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 11:15 PM
  4. [SOLVED] Code Produces Error When Trying to Operate a Particular Userform after Another
    By JP777 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-29-2012, 08:04 PM
  5. C# code works fine with Excel2007 but produces exception while running with Excel2003
    By shoebm_ms in forum Excel General
    Replies: 2
    Last Post: 12-18-2008, 11:23 AM
  6. C# code working fine with Excel2007 produces exceptions while running with Excel2003
    By shoebm_ms in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-18-2008, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1