string as range

  1. V

    Replacing < and > with numbers using If Then loop

    I want to scan a column of numbers that occasionally contain some values that have either "< 0.000" or a "> 10" listed. When I find them, I need to write a slightly different string set to an adjacent column. I also need to write an integer to a third column as a FLAG. So when I find the "<...
  2. E

    How can I use a string from a text box as a reference for a range in excel vba?

    Hi! I'm quite a newbie to VBA macros and I am in urgent need. I created a Userform to save some time with copy and pasting excel content. Now I have the following issue: I get a string output from a Userform - Textbox (txtHRS_ANW). I created exactly the same names as named ranges. Now I want to...
  3. B

    reading a string and only outputting the integers

    Hi I am trying to right a code that can read a set of strings that contains numbers and letters and I want to output only the numbers here is what i have Function ExtractNumber(rCell As Range) Dim iCount As Integer Dim i As Integer Dim sText As String Dim lNum As Long For iCount = Len(sText)...
  4. D

    Converting vba string to a range

    I'm currently trying to copy a dynamic range based on the row number of a selected listbox item. I'm able to get the row number of the selected listbox item from the data tab in my file. I, however, am stuck when it comes to copying a fixed column / varying row range from this tab and copying it...
  5. D

    Need String As Range & Need Contents of Cell Developed Into This Code

    So this code works fine (it was provided by another member here at Mr.Excel.com): Sub GetTextOrHtmlFromIe() 'Standard module code, like: Module1. Dim bln As Boolean Dim NPOFile$, myFile$ Dim ie As Object, objDoc As Object, f As Object, fs As Object Const strMsg As String = "To get a text...
  6. L

    Selecting non sequenced cells in a range

    Hi, I'm trying to use the SUM function with non sequenced cell but the Range or any other function won't allow me to activate the selecting cells if there are more then 41 cell, I wrote somthing like so: Sub Test() Dim str AS String Dim R AS Range str = "A1,A3 ...... ,A57" 'this is only an...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top