Inconsistent Run-time Error 424 for basic VBA script

So, I'm running two basic scripts: One that adds prefixes to cells, the other which adds suffixes. These are being run on CSV files that are used for database purposes. Here is the suffix one:

Please Login or Register  to view this content.

These scripts had been working fine up until recently. Now, sometimes they work, and then sometimes they just won't execute. When I debug, I get a Run-time error 424: Object required. I don't know why I'm getting that error. I thought it was because the cells were locked (which they are by default for some reason, I don't know why). But it works sometimes when the cells are locked, and when it doesn't work, it doesn't seem to matter whether the cells are locked or not.

I'm trying to figure out why it keeps happening. Is it because of the files themselves (which, despite having a CSV extension, Excel initially recognizes as Unicode Text)? Is it Excel? This is beginning to frustrate me, because it's part of a big project that I need to complete.

Originally Posted by Norie

Which line of code do you get the error on?

Line 10 in this code.

Due to this line of code

Please Login or Register  to view this content.

I'm surprised you get any error messages.
Also which line do you think is line 10?

Deleted as duplicated

Originally Posted by Fluff13

Due to this line of code

Please Login or Register  to view this content.

I'm surprised you get any error messages.
Also which line do you think is line 10?

When I debug, I remove that line to ascertain the error.

Also, I meant Line 11, which here is:

Please Login or Register  to view this content.

It is hard to believe protected csv, but have you tried

Please Login or Register  to view this content.

Originally Posted by jindon

It is hard to believe protected csv, but have you tried

Please Login or Register  to view this content.

That didn't take.

Further analysis, this is the line that triggers Error 424:

Please Login or Register  to view this content.

Also, I should note: When Excel initially opens these CSV files, they are treated initially as spreadsheets but save as text files. Subsequent opens result in a Text Wizard opening, followed by the sheet turning to an incoherent blob of data. I'm not sure if that's of any significance.

Delete (wrong thread)

Originally Posted by Norie

What range are you trying to select/set here?

Please Login or Register  to view this content.

The usual range I input is for a single column, save the top cell (which is a field rather than a value for what it's being used for). I run these scripts a few times for different columns.

Originally Posted by Norie

Do you need to manually select the columns?

I can either manually select the columns or type them into the input box.