rfind

  1. S

    VBA - Find value in another sheet, add date in next column

    hi folks, wondering if you knowledgeable people can help with this code. I have written the following code and need some guidancewith it please. I run a WB that tracks make-to-order demands with a longlead-time. Within the WB I have a sheet called ‘Hastener’ that I use toperiodically chase...
  2. G

    Finding EXACT MATCH

    Morning, I have the below code which works well with a bit BUT. It searches in the wsData for Range("D11:N11") - which are numbers - and then copy/paste the entire to a different worksheet (Macro Statement.xlsm). The problem is that I would like it to find a perfect match for the range as...
  3. T

    Delete Data Entries Based on Table Row Deletion

    I have two tables, one that feeds the other based on user entries. This the only interaction, add data to one and it feeds data to the other. The problem is, if I delete information from the feeder table, the records are still kept in the storage table. This is a problem as projects are...
  4. M

    Macro edit range to copy

    Hello everyone, need your help to edit the following macro: Sub x() Dim myValue As Variant myValue = InputBox("Give me some input") Dim rFind As Range, ws As Worksheet, wb1 As Workbook, wb2 As Workbook Dim RngCp As String RngCp = Rows("2:" & Range([A1]...

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