1. P

    How to select all the cells with the same font?

    Hi All, I want to select all the cells having the same font ("AmplitudeTF"). The recording option gives the following: With Application.FindFormat.Font .Name = "AmplitudeTF" .Subscript = False .TintAndShade = 0 .ThemeFont = xlThemeFontNone End With But...
  2. P

    VBA - Error 13 - Type mismatch

    Hi, I have this macro which looks for the unit 'ps' in Column Y and multiplies 1E+12 with the corresponding data in column AC. When it tries to multiply 1E+12, it throws a type mismatch error. Below is the code. Sub Multiply_Tdata() ' ' Change the value of the data (AC) column - multiply by...
  3. D

    Find all values that match anything in a range

    I just learned how to add in Excel a couple months ago and, although I'm doing the best I can with google, VBA is not easy for me to work with yet. So, while I certainly appreciate any sort of help, explanation-heavy answers would be doubly appreciated! The excel file I've attached should...
  4. S

    Excel VBA - Match cells, copy & paste

    Any help is appreciated. I am trying to use VBA to find all values in Sheet2 based on a list that changes in Sheet1 and copy the values to Sheet3. I would like Sheet3 to change everytime the list changes on Sheet1. Here is an example: Sheet1: Here are the names (A2:A10) that change based on a...
  5. E

    VBA Search with multi column/results

    I have searched several sites with no avail. If anyone can see what I'm doing wrong in this VBA code I would greatly appreciate it. I am getting an object required error at: Set c = .Find(strFind, LookIn:=xlValues) Private Sub SearchData() Dim strFind As String Dim FirstAddress As...
  6. G

    "Find All" Code Results Information Storage

    I'm a bit of a visual basic noob, and may be in over my head here... I'm having difficulty using the following "repeating search code" to store the row information of the results, allowing me to display them on a user form label box later. Private Sub getVendorButton_Click() 'Search Prompt...
  7. J

    Listbox List All Found Items Only

    Hi, I would like a script which will put all found search items in a listbox. Basically I search for whatever value I type in textbox1 and I want listbox1 to return all the results. my search code is: Cells.Find(What:=TextBox1.Value, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _...
  8. L

    Search Code Deciphering Help!!

    Hello All Thanks for helping me out before. I was wondering if you could help me understand this piece of code I am trying to use. I have a database that uses a userform to enter data. I am trying to decipher the search function I found on the internet so I can integrate it with my code but...

Some videos you may like

This Week's Hot Topics