Search results

Dave and NARAYANK991 well done seems to have solved the crashing Any chance of explaining why the new lines of code solve the problem or is that a new discovery for me. ;-)

NARAYANK991 thanks for trying to help. But I am simple when it comes to VBA. it took me long enough to figure the code I do have that works. So in short any chance of posting the exact code using your new suggestions.

Dave thank you for your help seems we must be missing something. Tried your new suggestion and ran the same tests. Did exactly the same. Rather than clicking end I debugged and it was the new line of code causing the issue. Fell over exactly the same. So started from scratch and tried first...

Looks fine changes the search value to 5000 Run-time error '28' Out of stack space so clicked end and tried again changing the search value to 50 Run-time error '2147417848(80010108) Method '_Default' of object 'Range' failed. That then crashes workbook.

Dave added the line in my code. Saved the code and closed the workbook. Reopened the workbook, enabled macros and checked the code was updated. Then checked it worked by changing the search value to 5000 which found one record and get debug issues but it show one record which is correct...

Well you cant say people are not helpful on here. Wow that was quick Dave. Tried your suggestion and it broke everything. VBA crashes workbook and if it stays open long enough when you find more than 10 results the scroll bar doesnt work

Hi everyone VBA is my weakest link and I really struggle with the basics, but I am determined not to let it beat me. I have atable of data which I can search and dispaly the results in a scrollable list. I have written a small piece of code Private Sub Worksheet_Change(ByVal Target As Range)...

How about this =SUMPRODUCT((Sheet2!$E$3:$E$12=$B$3)* (Sheet2!$C$11:$C$12=$E$2)* (Sheet1!$F$2:$F$12="YOUR CONDITION"))

Narayan you are an obvious genius and so quick. When you see the answer it make sense straight away. Sometimes you can't see the wood for the trees. Thank you very much for such a rapid response. Kudos to Narayan Ian M

Hi Guys and Girls I have been an avid reader of both the forum and Chandoo's blog for quite a while now, and still continue to learn everyday something new. Now its my chance to ask a question. I have sample table of data 6 columns by six rows. I have solved the problem of extracting a column...