addstr

Hi, How can I delete only empty columns within a selected range This is the code I am using, It merges columns together based on string delimited input but I want to delete only the empty columns from the column selection, Can someone help with this please Sub MergeColumns() Dim i As...

Hi I am using the code below to open programs if the user types in the correct word, however I'm not sure how to add an Or Statement or if I need to add individual words to be found. Can someone help with this please. So for example I want to these optional words to be used in the CASE...

Hi, Is it possible to match and Input box answer against RegEx so Special characters are used, can someone help please? This is what I have so far Dim MyStr As String, addStr As String, RegEx As Object On Error Resume Next addStr = InputBox("Cells...", "Enter Character") Set...

Hi, I am trying to set my range so that the header is not included How do I do this. This is what I need to change to start from the next cell below the Header found. Set Rng = Rng.Resize(Cells(Rows.Count, Rng.Column).End(xlUp).row) Dim xTitleId As Variant, Rng As Range, x As...