type=8

Hi dear, I have this code to delete data based on selection range: Sub DeleteSelection() Dim myrange As Range On Error Resume Next Set myrange = Application.InputBox(Prompt:="Select your range:", Title:="Delete Data", Type:=8) If Not myrange Is Nothing Then...

Hi there, I am not familiar with VBA at all. I need to replace a whole set of alpha Xpath values that look like this: ISOXML/Pmt/CrdtrAgt/CrdtrAgtTp/Nm ISOXML/CasePmt/Agt/Nm I have two columns set like this with the quotes to indicate that I want the whole string changed match for match...

Hi all, I hope you can help with the code below which was taken from an online source "Ktools for Excel", this seems to work but needs adapting in the following way. Is anyone able amend this so that the replace range can "Match by case" and "Match entire cell contents"? [Sub...

Hi, I've been trying to search for ways on how a userform can function as an inputbox of type:=8 but still got no luck. Basically, what I want is to let the user choose a workbook and a worksheet that is why I use the type:=8 of InputBox method but I want to replicate it using a userform because...

in using the following vba code below: this will work when i chose a one dimensional problem ie i want the value in cell BA7 to equal that in cell V7 by using goal seek to change the valve X7. Not seeing why i can't change values in column BA to equal those in column V by changing column X. in...

I have many different macros doing different actions within a spreadsheet by the user selecting the column first and the macro takes action on that column. Example: Sub CopyColumnOfData() Dim r As Range: Set r = Application.InputBox("Click in the column to filter by", Type:=8) Dim iCol...

I need to add a fourth array, range and augment code under the srartrange.select section Sub cartesianproduct() Dim startrange As Range range1 =Application.InputBox(Prompt:="Please Select First Range", Type:=8) range2 =Application.InputBox(Prompt:="Please Select Second Range", Type:=8) Set...