Results 1 to 7 of 7

VBA code leads to #value! in cell but works in immediate box

Threaded View

bpage VBA code leads to #value! in... 12-24-2014, 03:18 PM
Marc L Re: VBA code leads to #value!... 12-24-2014, 03:26 PM
bpage Re: VBA code leads to #value!... 12-24-2014, 03:37 PM
Marc L Re: VBA code leads to #value!... 12-24-2014, 03:46 PM
bpage Re: VBA code leads to #value!... 12-24-2014, 04:04 PM
Marc L Re: VBA code leads to #value!... 12-24-2014, 06:15 PM
bpage Re: VBA code leads to #value!... 12-24-2014, 06:42 PM
  1. #1
    Registered User
    Join Date
    12-24-2014
    Location
    Sunnyvale CA
    MS-Off Ver
    2010
    Posts
    4

    VBA code leads to #value! in cell but works in immediate box

    I have written a getprice function for retrieving stock tickers from yahoo and bitcoin prices from an online api. However the code for bitcoin results in an #value! in my excel cell. But it performs fine when I run the function from the immediate box in VB. I sense it's some sort of compatibility problem but I've exhausted my troubleshooting knowledge. Any help or pointers would be appreciated!

    here is the file
    https://drive.google.com/file/d/0B-C...ew?usp=sharing

    Book3.xlsm

    Book2forMrexcel.xlsm
    Last edited by bpage; 12-24-2014 at 06:47 PM. Reason: Book3 has the FIX

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Code works when cell is manually changed only the first time and not with vba
    By sdl2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2014, 08:18 PM
  2. how can i make this code works for multiple links it only works for one link
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2014, 08:38 AM
  3. Embedding Files - Leads to Registering at Site - Leads to Introduction
    By Shantel in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-19-2014, 07:22 PM
  4. Replies: 1
    Last Post: 10-17-2012, 03:34 PM
  5. [SOLVED] Organize spreadsheet of sales leads by zip code?
    By lilcolombo in forum Excel General
    Replies: 0
    Last Post: 11-24-2005, 02:50 PM

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