Is it possible to write code to modify code for new columns?

[sspatriots]

I have this code that has a lot of references to many columns in it.

For example:

Worksheets("Jobs").Cells(i, 24).Value

The problem I will be facing soon is I will most likely have to insert 3 new columns on the "Jobs" worksheet that will be in front of many of those references. Just wondering if there is a way write something that will take for example ".Cells(i, 24).Value" and change it to ".Cells(i, 27).Value" or ".Cells(i, 30).Value" and change it to ".Cells(i, 33).Value" for all references with a column greater than 10.

Just curious as to how doable this kind of thing is.


Thanks, Steve

 

[RoryA]

You were populating the job_name variable after you tested the cell value to see if it matched. So you were actually looking for a blank cell, which is why the other controls stayed blank.

 

[sspatriots]

You were populating the job_name variable after you tested the cell value to see if it matched. So you were actually looking for a blank cell, which is why the other controls stayed blank.

Ok, I see that now. I printed them and put them side by side. Thanks for that explanation.