mytext

Hello, I need to apply my split macro to range of cells. I currently have cell D4 selected but I need the range D4:D100 to be affected by the macro. How do I type that range out? I've tried typing MyText=Range(Cells(3,4),Cells(100,4)) but it did not work. See below for my current macro. Thank...

Hi to all, I have an excel file and I want to export the contents of text cells (range C2:D5) ... in a file.gcp (is a text file)....maybe someone has a VBA code ... to export values from range C2:D5 like this: MYTEXT A-z,1.00,2.00,MYTEXT Z-a (where 1.00=C2 and 2.00=D2) MYTEXT...

I have a sting and the code below works find to return the name. I just don't understand what the numbers in the parenthesis are doing? DEMOGRAPHICS NAME: Donald J. Duck BANK: 451CS Sub trythis() Dim MyText As String MyText = Trim(Split(Split(Range("A1"), "NAME: ")(1), "BANK:")(0))...

Hello guys! I'm pretty new to VBA and macros, and I need your help :) Basically, I was using this code to search my whole workbook (contains 5+ sheets) for a specific text (name for example). Public Sub FindText()'Run from standard module, like: Module1. 'Find all data on all sheets! 'Do not...

Hi! help for this, please, thanks. Dim n As Long, rng As Range, t As String rng = Worksheets("Utdata").Range("E4:E500") t = "MyText" ' 'I want to fine total nummer of MyText in this range. ' Range("H3").Value = n