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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top