Posts by jeran042

    So I have some code (see below) that works as intended when I was running it within the desired workbook.
    However, when I added it to my Personal Workbook (more accurately an Add In i built) it does not execute they way I want it to, and here is why.

    There is an IF Else If Statement which looks at the name of the workbook, and based on that, executes a set of commands. The problem now is (I believe) that the code is not seeing the name of the workbook, but rather the name of my Add In.

    My question is this, how do I pull the name of the workbook, and not the name of my Add in?
    The name of my Add in is "LAST_NAME.xlam

    See code snipit:

    Any help on this particular issue or any suggestions on improving this code is greatly appreciated

    Good morning all,

    I have a loop that I am having trouble getting to work the way I desire. The purpose of this loop is to look in column "J", and if the value ISTEXT, offset the value 1 column,
    However what is happening is that it sees the first cell in the column, and it is in fact text, and it is just offsetting 1 column, not moving the value, or continuing the loop,

    Here is what I have so far, any help or guidance is appreciated,