Folks,
Can someone tell on what we are discussing about in this thread, i will be
too interested in learning this as i deal with PO numbers and purchasing.
With Regards,
R Karthikheyan
On Tue, Mar 23, 2010 at 2:23 PM, paulwillekens <
paul.johan.willek...@gmail.com> wrote:
>
> Hi Colvert,
>
>
Hi Colvert,
Well, I think you could keep that "last purchase order number (PON)"
in a (protected) fix cell, e.g. D1
Sub PON()
ActiveCell.Value = Range("D1").Value + 1
Range("D1").Value = ActiveCell.Value
End Sub
Is that what you're up to?
Greetings
Paul Willekens
--
--
