mytext

  1. J

    Applying a Macro to a range of cells

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

    Help - export range with vba to txt file

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

    VBA: Split string between two words to extract sub string

    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))...
  4. Z

    VBA search macro

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

    Cout text in a range

    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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top