You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
but I don't want to write out REC1-REC1000 and replace with 1-1000.
Also, this. Don't do this, but if you ever do find yourself having to write many (maybe thousands is excessive... ) of lines of very similar vba, you can set up a formula to actually write the vba for you on the worksheet.
In this case it would be a formula with your line of code in with "...." & A1 & "....", where A1 -> A1000 contains the numbers you want in the vba. You then paste the whole thing into your vba. Does that make sense?
It's utterly filthy but takes seconds, I'll admit to having done it on occasions :)
christianSpaceman
@Chalfie
I have a question, hahahaha, my find replace array is working well. I've noticed one user is populating a lot with
RECx
where x = a number
My find replace array thing currently has REC3 and REC2, but I don't want to write out REC1-REC1000 and replace with 1-1000.
How can I say REC* and then in the replace column just have the number?
sorry for making no sense.