Don't know how to explain this in the heading so sorry. I have an excel spreadsheet set up as shown in the attachment. When I insert data by using the macro (Insert farm), for some reason it puts a NA in a cell (C17). I then select the cell click into the formula and click enter and it works. how can this be fixed. Look at the excel spreadsheet to be able to understand.
Last edited by dextras; 06-28-2009 at 06:10 AM.
It would appear to be the case that you're running in Manual Calculation mode thus the formula calculates when first inserted, at that point the co-ordinates have not been assigned (xxx|yyy etc) and as such the result is #N/A ... once the input co-ordinates have been inserted you need to enforce a recalculation so add:
prior to the End If statement (or alternatively switch to Auto Calc mode)
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
thank you so much again. i would +1 but can't lol
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks