Hello,
Sorry to revive this old thread but I'm having issues getting this code to work for my needs. I started with the above attached "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 my edited code:
Bookmarks