Hello and thank you for your time.
I am trying manipulate some code that I found in another post "VBA to Delete Specific Columns 100s Files for .csv "
I started with the file that was linked to the above linked thread "EF975086 code.xlsm " file and I'm trying to modify it. I'd like to delete the entire row if the text value matches what I have specified. I'm working with multiple csv files (batch) and all of the data is in column A. I've been able to get the macro to run but it does not delete the rows of data that I am trying to remove. Rather, there are no changes made.
I need to delete the row that contains the following strings.
Date/Time, Time stamp, Cycles of Channel 1, Channel 1-Displacement, Channel 1-Load, Channel 1-Dyn Load, Channel 1-Accel
s, s, cycles, mm, N, N, G
I very much appreciate your time on this matter.
Here is the edited code:
Please Login or Register to view this content.
Bookmarks