.find

Hi Guys, I am currently working on tool for my team that would enable them to add events to their projects, based on date. Currently I have a following s/s: <tbody> A B C D E F G H I 1 Project Calendar 2014-12-15 2014-12-16 2014-12-17 2014-12-18 2014-12-19 2014-12-20 2014-12-21 2014-12-22...

Hello, I am trying to get the values from merged cells (which are at the offset of a .find gcell result) through a loop that goes through rows one by one (and looks for specific values on an other sheet) .This code goes if the cell we are looking for is merged and does the following...

Hello, I am developing a code to search in an external workbook a determinated value, the fact is that external workbook has many sheets and we are having trouble making the code to search in each sheet. Here I leave you the part of the code that, without the red part, works when we look in a...

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...

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 =...

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...

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...

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...

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...

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...

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...

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...

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...

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"...

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 =...

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...

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...