Change Syntax to Eliminate XLA File?

[sadele89]

I am trying to recreate an excel file that performs various calculations using various functions. The original excel file has two accompanying .xla files.

I am wanting to eliminate the need for the xla files by copying functions directly into my excel file within a single module. However, there are various functions with Application.Run referencing the xla file (psychrometric functions.xla).

For example, this code in one of the xla files is referencing a function from the other xla file (psychrometric functions.xla).

Please Login or Register  to view this content.

Since I will now have the referenced functions (TbdTwbtoGrains) in my Excel file, how would I change the syntax?

My VBA knowledge is very limited, as well as my knowledge of the calculations. Any advice would be appreciated. Thanks!

[gscript]

You can use simple if for w1 or w2.

Am I wrong?

[sadele89]

Fixed it

Please Login or Register  to view this content.