View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default interesting interpolation

Your attachment didn't make it through - good thing - attachments are tabu.

Repost and put your stuff into the post (not as an attachment)...

--
steveB

Remove "AYN" from email to respond
"nelg" wrote in message
...

G'Day guys,
need some help with this code. am trying to do a graphical
interpolation by VB.

I have attached a simple example of what I need. The values column need
to be filled!

Any idea? So far I can get the initial cells. For example for the first
two values I can get out 2 and 3 in the A axis and 4 and 5 in the B
axis. But keep getting errors everytime I try and get the four cells
which the above 4 values intersect at (as soon as I can get those
intersecting cells it is simple maths, no problems).

Thanks in advance for any ideas.


+-------------------------------------------------------------------+
|Filename: Interpolation example.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3875 |
+-------------------------------------------------------------------+

--
nelg
------------------------------------------------------------------------
nelg's Profile:
http://www.excelforum.com/member.php...o&userid=27771
View this thread: http://www.excelforum.com/showthread...hreadid=472841