Hi. I have written a very simple function in VBA with 5 arguments. To support my query here's an example of the function definition: Public Function Week_Stock(cini As Integer, cfin As Integer, Stock As Double, row As Integer, prev As Integer). Each of these arguments are linked to an excel cell. My problem is that although every cell contains a value the Stock variable is always zero. I've checked the formatting of the cell and it's defined as number. If I do Copy-Paste Values it is properly passed onto the function. Can anyone help me understand what may be causing this? Thanks. Pedro
--~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
