Search results

Hi I am writing a code that looks through a range and looks for values that contain "ADR". The range i am using is Range("D" & i).Select My question is: How can i replace "D" with a counter or a variable, so that when it is done with column D it will move to the next column. My code...

Hi guys I am trying to write something that take value from page 1 and looks for that value in a given range in page 2. I then want to make a loop so that it looks for that value in page two until the search returns no results. This is my code: a = Cells(counter, 3).Value Do...

Hi everyone I have a excel spreadsheet that imports files from several locations and drives and saves them all in one location. Then I have an Access database that has a macro in a form that imports all these files into the database and into the appropriate tables. What I want to do is...