Forum Discussion
Writing VBA code for Excel Spreadsheets
Hello, I am writing a code in vba for an excel spreadsheet that takes an array of dates for a particular sheet, and iterates through the array for each row of the sheet. If the code finds the the dat...
Changing the price amount array data type from integer to long won't fix the problem (long is still an integer). You need to use a data type for the array containing price amounts that supports decimals, such as single or double.