Showing related tags and posts accross the entire site.
-
Richard That makes it quite a bit more complicated, at least for me. Someone like Bob who does magic with Functions will chime in I'm sure. The solution I have come up with uses a UDF (User Defined Function). (as below) '------------------Start Code--------------------- Public Function FindHeading...
-
Gary Caveats (This is to get you started. NOT optimised or tested thoroughly. Certainly not Internationalised for dates, should work with US mm/dd/yyyy format). Comments to help. I have to iterate the range of holidays as NETWORKDAYS will not work in the code if not available on the machine as the VBA...
-
Gary I always use a UDF (User Defined Function) like that below. Public Function FindLastSpace(sInput As String ) As String Dim iLastSpacePos As Integer Dim iLengthOfString As Integer Application.Volatile True iLastSpacePos = InStrRev(sInput, " " , -1) iLengthOfString = Len(sInput) FindLastSpace...