string address

Hello, I have two strings of letters (columns String A and String B) and I want to transform them into strings like the ones in Solution 1 and Solution 2 correspondingly. In the case of String A, I need to remove any adjacent duplicate characters, so the string ZPDUU would turn into ZPDU...

i have a code that counts colors on a sheet. Colors blue and Yellow. The code is on each sheet it works on. i like to modify it to work off a module and use a cell value to call what sheet to use.here is the working code from sheet: Public Sub DEISOBUTANIZER() Dim db As Object, dy As Object...

Hello, Does anyone know the bug or problem where you get an error message (error 9 or 91) when you address a "window" or a "workbook" with a string like this? strFile = "NameOfWorkbook" Windows(strFile).visible = false Workbooks(strFile).Close The strange thing is, that this code is...

Hi Mr.Excel, I am looking for vba code or formula where I can search number in the given column (this column combination of numbers, text and special characters). In this I would like to take only number which I require or entire cell which contain the requested number, if provided number does...

Hi. Here is the code I've created: Windows("Banana Republic (99316).xls").Activate Sheets("My Favorite Store").Move After:=Workbooks( _ "My Favorite Store Macro.xlsm").Sheets(1) Sheets("Controls").Select The goal is to be able to manually download the Banana Republic...

Just curious if a string of data can be returned if a set of criteria is met: Here is where I am going with this. <tbody> A B C D 1 123 Main Street Las Vegas, NV 88888 Criteria 456 My Avenue Miami, Florida 55555 2 456 My Avenue Miami, Florida 55555 Avenue 3 789 Their Boulevard...

Hi all, I have a cell that has the string of a cell address in it say Cell A1 has the string B2 How can I in VBA look at this cell and use the text inside as a range the same as the INDRIECT function. Also can the cell I am looking at for the string be set as a Dim so if the contents change...