Delete rows beginning with !, Add new first row.

I'm sorry if I misunderstood, but I read the rules, and even edited my post to mention that I posted the question on another forum as soon as I made the second post.

3. Questions that are cross-posted to other web forums must contain links to those posts on those forums or a comment to tell us where else the question has been asked. (A, Z*)

But the rules also stated not to post links to competing forums, so I said the name of where I posted it instead.

10. Do not put links to commercial sites or services or to competing forums in signatures and posts. (A, B)

The rules I quoted came from the forum rules page found at this website with the following after the .com /forum-rules/642590-forum-rules.html sorry, I would have posted a link to show you, but I cannot post links, I'm guessing because I don't have enough posts yet. Which also brings up a second point I was unaware of, if I cannot post links, how would I post a link to another forum even if I was mistaken.

If I read the rules incorrectly, perhaps they could be edited to be made more clear to avoid this type of situation with new users in the future.

After that whole explanation, it comes down to one thing. Do you want me to post a direct link to my question if I post it in a competing forum in the future? If that is the case, how many post must I have in order to post a link? I will do my best to get to that point.

-Trent Spencer - KM4YTU

Some progress has been made on this problem by user Fluff at the MrExcel forums. I swapped out a section of my code for his suggestion, replacing the two sections that delete rows that start with ! and add a row with headings.

The new code seems to delete the rows with comments beginning with ! just as expected (regardless of what s2p file I load), however when inserting a row with headings I get an error stating that there is already data there (only on s2p files that did not have rows with comments at the top of the file), and asking me if I would like to replace it.

Adding to the issue, while testing the new code with other .s2p files (files without the !comments at the top) I found that the delimiting of the data does not always work as expected, and produces a completely different outcome. I noticed that when viewing the file without !comments in a text editor such as Notepad++ that the columns of data do not line up exactly. This appears to be due to the addition of the "-" for negatives, as well as leading and trailing zeros causing issues. I suspect that the data being formatted this way is the reason for the delimiting problems I am now having to some files.

Attached below is the new code, with the changes Fluff suggested added to it. Also attached is a screenshot of how the delimiting is broken with some files.

Please Login or Register  to view this content.

Sorry, I cannot upload a screenshot until I have more posts, however I will describe the problem as best I can.

The first row (1) is correct [it does produce the error I mention however]. The first column (A) is correct. The last four columns (H:K) are correct. However the second through seventh columns (B:G) [with the exception of row 1 from those columns] are empty, with the data that was supposed to be in them apparently deleted.

Any suggestions are welcome.

EDIT: I mention the progress from the other forum in order to stop someone else from working on an aspect of the problem that has already been solved.

I was under the impression that I didn't need to as you said that you did it for me because I had less than 5 posts. But since I can post links now, and in order to comply with the rules after your clarification I will also include it.

I have asked this question *here* at Excel Forum on Tuesday 09/24/2019 at 13:19 CST
excelforum with this after com /excel-programming-vba-macros/1290901-delete-rows-beginning-with-add-new-first-row.html

I also asked the same question in one other forum, Mr Excel, a few hours later on the same Tuesday 09/24/2019 at 15:54 CST
mrexcel with this after com /forum/excel-questions/1110666-delete-rows-beginning-insert-row-text-into-multiple-sheets.html

Well, I tried to and still cant post links, so I left the link in and "broke" it by removing the protocol and domain, I hope that is okay.
At this point I feel like I need to prove myself, so here is a [broken] link to a screenshot showing me being denied posting a post containing a link.
drive.google with this after com /uc?id=1UtCeVgl3z-2hVuXna-EO_i5CJV21LcE9

This problem was solved by user Fluff on the MrExcel forum's at the following link with the following code.

mrexcel dot com /forum/excel-questions/1110666-delete-rows-beginning-insert-row-text-into-multiple-sheets-post5347700.html#post5347700

Please Login or Register  to view this content.