<div dir="ltr"><div>Yes....if I don't use ",g" then aa is always blank, when put in the subtotal section of the output format.....if I use ",g" then aa is always equal to ab -- so in the instance of client 5499, aa and ab are both 0091</div>
<div>..and I thought you said 'not' to use ",g" ?</div><div>So aa should be (4,#,g)? Only aa should be ",g"? Not ab?</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 14, 2014 at 5:34 PM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>On 7/14/2014 4:59 PM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
Yes that's what it said - so I did as you said and yes, in fact the beep<br>
msgbox only is encountered once - thanks now line 1 is blank in the If:<br>
and Then: end<br>
Now if I can just figure out why aa is always blank then I'll be<br>
set.....thanks for that tip....<br>
</blockquote>
<br></div>
You keep saying that aa is blank when you don't have ",g", but that it has a value when using the required ",g".<span class="HOEnZb"><font color="#888888"><br>
<br>
-- <br>
Kenneth Brody<br>
</font></span></blockquote></div><br></div>