GlennUK,
thanks for that it works a treat, don't mind complicated just as long as it works.
(With regards the ther posts, I don't know VBA and didn't want to use text to columns as wanted to create something with as few steps as possible for the end user to work with.
Thanks to you all.
Jamer101
Help ?
I have a column within Excel (2003) which contains several elements of data, is there a way without using text to columns that I can pick the Nth element of data. The data is delimited.
eg
A1 contains "Frank,Betty,Alfred,Stan,Peter"
in B1 I want to display the 3 element of data...
Have now resolved this issue, appears to be a lag with the network drives, have set up a new NFS on clustered netware server with better disk set up and all is now OK.
[pipe]
I have a HP-UX 11.00 system on which we have mounted a netware volume using NFS, all is working OK from the network side in that we can copy files move them around etc.
However looking at this drive from Unix I can view files OK, but when I create or copy files the system does not appear to let...
When we create a new user within iManager using the copy facility, it brings across the old users Groupwise email information. Is there a way of suppressing this ?
Thanks for that, I had a play with the code below,
WhilePrintingRecords;
Not InRepeatedGroupHeader;
NumberVar MyVariable := 0
but it didn't work, so I have picked up on your other point and removed the group headers from subsequent pages, this works fine. I will have another go with the...
I have followed the steps posted by others on subtotalling formula fields (FAQ149-182) and everything works OK, except where the group I am totalling goes over a page, in which case the running total is reset to zero. I presume this is because the group header falls under the page header within...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.