A macro that only runs on a group of concurrent(?) rows with specific data in one column.

First, the devs on this site are incredible. We tell everyone about this site, head and shoulders above other similar sites! Thank you!


Ok, I've been trying to figure this out for a long time! It's really past my level.

This is part of a fairly complex Excel Macro, that I plan to Call near the end. I can post the whole Macro if needed.

Simply put, we need an Macro that looks for TX in column F, and the good news is that those rows are always concurrent(?), say all rows 35 through 48 or 41 through 62. As you can see, which rows in any given file are variable; my personal dilemma.

All entries are in a single worksheet, sorted via State in column F, with data in columns A through P, and tab delimited.

So the action to apply on all rows with 'TX' in column F, is a custom (expanded) sort via Column C, the phone number.

That's it. If the rows were always the same numbers, no problem, but it's variable; my nemesis.

Thank you for any help you can provide!

Thanks Mumps! I think it's real close.

It breaks on line 8
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear

run-time error '9':
Subscript out of range

Not that I thought it was related, I did try replacing "Sheet1" with "CurrentLeadFileUsing.txt" since I know the file name at this point in the script.

Here's an example of a generic file just in case. http://onlineautomation.com/download...adFileUsing.7z

Thanks again!
Mark

Sorry about that. It's just compression. Here's the more standard zip file.

http://onlineautomation.com/download...dFileUsing.zip

It is a tab delimited text file of course, one of the std files for Excel.

Thanks again!
Mark

Spot on Mumps!

Oh I was SO close with that last one! lol