Recent content by drew23

Namliam I have tried that, but this than affects line mycheck = Range("d" & i).Value Like "*ADR*" for some reason when using the cell method it does not find any valued that contain adr. It only works with a range method. tks

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

Nigel Thanks for you help. I can't use the v/d lookup formula because i dont know the exact name of what I am looking for. ie I am taking the first 6 laters from the names in sheet 1 and trying to find all the words that contain these first six letters in sheet 2. All the words in sheet 2...

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

Thanks DCrake Tried that and i get run-time error message 2486 Application-defined or object defined error. This is the code i use. the line in red is the one that fails. Thanks 'to open dtb Set oApp = CreateObject("Access.Application") oApp.Visible = True...

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