Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by hhap
-
Loop thru cells and copy content based on a criteria
Thanks to BrianB, from another site, I have a perfect solution to my question. It worked so well I decided to post it here for other users of the site as well. '============================================================================= '- macro checks each value in Colmn W with the checklist...- hhap
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Loop thru cells and copy content based on a criteria
Crystalyzer thanks for your quick reply. However when I run the code I got a Run-time error '1004' on the following code FoundRow = Application.WorksheetFunction.Match(Val, MasterList, 0) The message that appears is as follows "unable to get the Match property of the Worksheet Function Class"...- hhap
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Loop thru cells and copy content based on a criteria
I have a worksheet with data that goes up to 20,000 rows and 60 columns depending on the amount of data entries for the period. The entries for a particular column (column W) were not properly entered and therefore some of the data that should appear under column W appear under other columns but...- hhap
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
