xtitleid

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...

I am working on an Excel worksheet based on a MS Project file, and I am trying to write a macro that can group my rows by the WBS number in column A. I am trying to do this by using the formula below. Here is my attempt so far. While the input box does appear, nothing is grouped. Any help would...

I am trying to write a macro to group my project schedule in Excel based on the number of periods in the WBS column. This is not working, but I feel as though I am close. Sub Group_1() Dim cell As Range Dim WorkRng As Range Rows.ClearOutline On Error Resume Next xTitleId = "Grouping" Set...

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 am trying to use this replace text/phrase by comparing the values into diff sheet, if the the comparison exist, then replace a different text, it works when i use it for a few words value, but i have to replace a long phrases, i get mismatch error. Please help. I am using this to...

Hi, I want to set the input range and the replace range to fixed. Is that possible? //Per Sub MultiFindNReplace() 'Update 20140722 Dim Rng As Range Dim InputRng As Range, ReplaceRng As Range xTitleId = "ersätt" Set InputRng = Application.Selection Set InputRng = Application.InputBox("Original...

Hi experts, I have a VBA code which helps in extracting unique data from multiple columns. As of now, whenever you run the VBA it asks for am input range and an output range. Can someone please help me to eliminate the msg box and replace it with a dynamic range for say column A:D from...

Hi, Does anybody have any suggestions / alternatives to modify the below code to allow find and replace multiple values on all worksheets? Also, if there is a way to fix replacing range, rather than having to select it each time? Thanks Sub MultiFindNReplaceNew() Dim Rng As Range Dim InputRng...

Hello everyone, I have this code Sub CopyData() Dim Rng As Range Dim InputRng As Range, OutRng As Range xTitleId = "Lottery" Set InputRng = Application.Selection Set InputRng = Application.InputBox("Range :", xTitleId, InputRng.Address, Type:=8) Set OutRng = Application.InputBox("Out put to...

Hi Guys, Need your help. I need to unmerged Column A & B using this formula, can u please help me out. While using this code, it duplicates other columns available in the sheet Sub UnMergeSameCell() 'Upadateby20131127 Dim Rng As Range, xCell As Range xTitleId = "KutoolsforExcel" Set WorkRng...