Computing.Net > Forums > Office Software > excel macro reads wrong value

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

excel macro reads wrong value

Reply to Message Icon

Name: yoghurt
Date: February 27, 2004 at 07:21:35 Pacific
OS: Windows XP
CPU/Ram: 2.8 GHz, 1 GB RAM
Comment:

Hi,

I've got a horrible problem with my Excel macro. When I my macro reads a value from a cell containing e.g. 1.33, he reads 1.38! The type of variable where I store it in is a double. The commands I use are below. Does anybody have a clue? I would mean a lot to me if you could help me sort this one out!

Public m_dApproved As Double

With oProj
.m_dApproved = oInSheet.Cells(j + lInRowOffset, lInColOffset + 6).Value



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: excel macro reads wrong value

Excel Macro read and process CSV www.computing.net/answers/office/excel-macro-read-and-process-csv/3820.html

Excel Macro Nightmare!!! www.computing.net/answers/office/excel-macro-nightmare/1081.html

Excel Macro help. www.computing.net/answers/office/excel-macro-help/8054.html