I know this is not really Visual Basic.Net stuff but I would like help with one of my Excell spreadsheet ... it does have a visual basic macro in it

The excell spreadsheet was passed onto me by my boss and the person who has written it has departed ...

I am trying very hard to try to make scense of the formulas but I am not successful at it ...

Can someone please help me try to make some scense of this spreadsheet ...

It is not that complecated ...

It does have one visual basic macro that uses the goalseek function ...

I am also trying to find out how the write get the value for the Cell C23 ... for the "Gross" value ...

Can someone please help me out here ???

I will email the excell spread sheet to you ...

My email addresses are

I will greatly appreciate it if someone can help me convert this spreadsheet into Visual Basic.Net !!!

[email protected]
and
[email protected]

Ok, the type of VB that is used in Office is VBA (Visual Basic for Applications). Similar in that it uses the BASIC structure of code (top to bottom read, until VB came out), but different in that it has a lot of different stuff you can do that pertains directly to the Office suite.

My advice to you:

There is a forum here for Excel VBA, however it looks all but dead (quiet). It can be located here:
http://p2p.wrox.com/forum.asp?FORUM_ID=30

Another option is http://www.tek-tips.com on their VBA forum (they have a very active VBA forum) for the information you are looking for. This seems to be your best bet, but I would try the local forum first just incase. Make sure to post the code that you are looking at ;)

As for the value of a cell, I believe it's Cell(#).Value . I'd have to look at the few VBA macros I've created to be sure.

Forgot one link, it's to the actual Excel VBA (not a specific book) forum here:
http://p2p.wrox.com/forum.asp?FORUM_ID=72