Excel Function Lookup

[saschmeling]

Can anyone tell me why this line of code is not working:

Please Login or Register  to view this content.

I keep getting an application defined or object defined error when I run it.

Here is the entire subroutine:

Please Login or Register  to view this content.

Basically, it should do the following.

Look at column A
If there is a number in column A
Look at the 0rg 5110 Projections Workbook Column 3
Return the appropriate number.


Open to any and all suggestions.

Thanks,

[MarvinP]

Hi,

How about this possibility. You are in Column 3 and you are trying to put a formula in it that takes a number from a column 5 to the left of column 3. That would be column -2 maybe? Perhaps the formula you are trying to put in the cell goes outside the possible range of cells/columns/rows?

[saschmeling]

Will look at that MarvinP. Thanks.

Got the code to work otherwise- found 1 issues:

1. Had to add an extra double quote at the end of the statement. Think this must fill the literal need- True/Fals.
2. Have to have the projections book open when running. Added a couple of lines of code to open the book, then close it when done. Sure there is a better way to do this, just don't know it right now.

If anyone has an idea how to cleanup the code and make it more elegant, it would be appreciated.

Thanks,
Scott