Trying to get two functions to work together

[Aussiexile]

Hi. im sure this is an easy fix (i hope) but im trying to get 2 functions to work (one calling the other) and i keep getting an error message (see Attached)

Please Login or Register  to view this content.

Any Help would be greatly appreciated

[romperstomper]

On which line?

[Aussiexile]

On which line?

how do i find that out. the error doesnt give a line number

[romperstomper]

Put a breakpoint in the first function, then when it runs, use f8 to step through line by line until it fails.

[Aussiexile]

On which line?

the error occurs at this point

Please Login or Register  to view this content.

[romperstomper]

Can you post a sanitised workbook as it's kind of hard to guess what sorts of values you are passing where. Nothing springs out as syntactically wrong on that statement.

[Aussiexile]

all the code is activated from workbook_change.

EDIT: I should probably add that u need to enter a number into col C in the format that is already there.

[romperstomper]

Your code is looking for a name called "Correspondence" which doesn't exist.

[Aussiexile]

Your code is looking for a name called "Correspondence" which doesn't exist.

crap. it does in the other sheet. sorry i thought i fixed those up

will fix it up and repost it.

sorry for the run around

EDIT: new excel attached

[romperstomper]

Your issue is this line:

Please Login or Register  to view this content.

in the PopDocTypeDisc function. Since DocTypeArray does not contain range objects, but strings, you cannot use Offset. (you can't offset from a string)

[Aussiexile]

Your issue is this line:

Please Login or Register  to view this content.

in the PopDocTypeDisc function. Since DocTypeArray does not contain range objects, but strings, you cannot use Offset. (you can't offset from a string)

would

Please Login or Register  to view this content.

fix the issue and if not any suggestions on how i resolve the issue?

on a side note thanx for all the help so far romper

[romperstomper]

It would certainly stop the error, but I don't know whether it would fix the issue, since I'm not sure what you were trying to achieve with the original code. If you were simply trying to use the next item in the array, then yes that will be fine.

[Aussiexile]

It would certainly stop the error, but I don't know whether it would fix the issue, since I'm not sure what you were trying to achieve with the original code. If you were simply trying to use the next item in the array, then yes that will be fine.

yeah on this particular item i have 2 discriptions that contain the same first letter in the code eg
one would be T1A and the other is TC the number or second letter changes so i need to check and see if the second char is a number if it is its "this" if its not its "that"

thanx will give that a burl and hopefully it will work