search range

  1. K

    vba to check a pivot table for a value

    Hello! I have a UserValue input through an InputBox. I would like to check a little one-column pivot table to see if that value exists in the table. If it does, I will pop up a message. If not, continue with the macro. This is what I wrote, but it's (obviously) not working. At the bolded...
  2. B

    VBA to complete a list with missing items

    Hello, I have two sheets: Sheet1 and Sheet2. In Sheet1 I have names (Name1, Name2, Name3...) and projects (Project1, Project2...). I mark with an x the name assigned to a project. In Sheet2 I have have the working days of the calendar and the names with their assigned projects. I would need...
  3. C

    VBA Question

    Hello, I am looking for help with a scrip. A play off of the following script if possible that would copy the cell, instead of delete the row: Set SrchRng = ActiveSheet.Range("A1", ActiveSheet.Range("A5000").End(xlUp)) Do Set myCell = SrchRng.Find("Agent", LookIn:=xlValues) If Not myCell...
  4. B

    Search a Range for changing Text

    It has been some time since I had to do some programming however; I am muttling through this project that I've been given. I am stumped at the moment and would appreciate some guidance from you guys. I have the following table and have my script to identify a change in software title and...
  5. P

    Range lookup problem

    Hi, I am having trouble working out this range lookup problem and would really appreciate some help. Still trying to get the hang of Excel. I am using Excel 2007, my computer runs on Windows Vista. Excel 2007 <tbody> A B C D E F 1 Initial Table 2 3 Price Range...
  6. H

    If "#NA" is in Range, Do this

    Hi All, I'm trying to make an if. I want it to search a range (N5-N30) and if the value "N/A" is in any cell, to click on that cell, move 8 over, then run the blue code (the blue code already works). Any ideas how to make the If, Then, Search, Offset, Select work? If...
  7. R

    Searching a Range For Two Known Text Values and Hiding the Rows in between.

    Hello, I am a beginner user of VBA and am having trouble finding a function to do what I need. I have a predefined range in excel (about 1000 cells) called Range 1. In this range I have the values "user" and "visitor". When a checkbox (chk1) is checked, I want a code to search Range 1 for the...
  8. L

    VBA Problem When Searching Sheet Hi All, I have been trying to work something out for 2 weeks but I cannot seem to do exactly what I would like. I have posted a download link (at top of post) which has a cut down version of my program, showing...

Some videos you may like

This Week's Hot Topics