.find

  1. J

    Simple VBA Help Needed - Search for a Value and Delete Row

    Hi - I created the following code to find the word "result" on a worksheet and if found, delete the row. The code below works but displays an error after it runs: Object Variable or With block variable not set The error relates to the code highlighted in blue below: Sub FindResult() Dim i As...
  2. I

    Find and delete header columns without a certain word.

    Hi, I need to: 1. Find a column containing the word 'target' in header. (from the range P1 to QI1 ) 2. Delete all other column without 'target' in its header. Sub Cleanup() Dim rng As Range With ActiveSheet.Range("P1:QI1") Set rng =...
  3. J

    Need ideas on copying columns from one workbook to another

    The reason I am posting is to find an efficient (read quick) way to copy a pair of cells from one worksheet to another using matching unique values in "A". Essentially, data is coming from two different databases into two spreadsheet reports with one having two cells per record that need...
  4. J

    Can you have two .Autofilters in the same macro?

    I know, it sounds like a silly question, but if I have an Autofilter range on one workbook and a .Find being used on the range, can I use an Autofilter on a second workbook? I am trying to use each within a set of "With" blocks...
  5. J

    .FindNext not working inside Autofiltered data after .Find works

    Everyone has the desire to learn while doing tedious projects, and this is one of my learning 'splurges'. I am using Excel 2010, the code is all in the same default macro module, and I know that I can loop instead of using the .Find/.Findnext functions. I am working on handling NULL fields in a...
  6. S

    .Find not working - returning the string I was searching for, not the location it found it in...

    I am looking for a varietey of data, based on what files are opened to begin wtih. The data (workbookA.sheet1.columnA) is saved to (set as the value of) a variable "resource_name" which should then search for it in the other sheet (workbookB.sheet1) to see if it even exists (in this case I want...
  7. L

    Looking for help with .Find

    Hello all, I am looking for a bit of help with the .Find function. I am trying to automate the process of checking for multiple duplicates but am getting stuck in 3 places that I am aware of at this point: 1. How do I tell my .Find to search within a specific column? Say, column B - I know...
  8. 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...
  9. T

    Find and Make Active

    Hi, i have found this code here which i am trying to adjust to my needs Sub finddate() Dim cl As Range Dim lastrow As Long lastrow = Worksheets("Filter_CSM").Range("A65536").End(xlUp).Row for each cl in Range("h2:H" & lastrow).Find(What:=DateValue(<>"")) If Not cl Is Nothing Then cl.Select...
  10. L

    Write contents of cell from one tab to another after .find

    I'm using Excel 2003. I have two tabs: AllTxt & ExtractInfo <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> In 'Alltxt', I need to find each occurence of ***. If found, I need to write the contents of that cell into tab "ExtractInfo". <o:p> </o:p> The...
  11. B

    Vba code to find value in excel dataset

    I have a (x,y) table of data in excel that I am trying to find a corresponding z value for. Here is an example of the dataset in excel: <table x:str="" style="border-collapse: collapse; width: 528pt;" border="0" cellpadding="0" cellspacing="0" width="704"><col style="width: 48pt;" span="11"...
  12. J

    Using .Find

    According to the help in the excel IDE, .Find returns a range object. So, why instead of getting a range, it appears to return the value I am searching for? Dim rFound as Range Dim iBr as Integer iBr = 3 With WB.Sheets("GL Transaction Totals - MTD and YTD") Set rFound =...
  13. M

    .Find over a range of cells not just a row.

    I'm trying to search for text over a range of cells. My code works for one row but I can't get it to work for a range of cell AP6:HM55<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Help please?<o:p></o:p> <o:p></o:p> With...
  14. M

    .Find text in coloumn and return row number

    First => I'm trying to return the row number of the first instant of the word "Day 1" in a column, looking down the column.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Second => Once I have the row number I will then format the columns C:N...

Some videos you may like

This Week's Hot Topics

Top