Hey There,

So I basically need to create the inverse of a function that I have which is about 1000 lines of code...

The main objective is that code like

Code:
Sheets("nindex").Cells(1, 2) = Sheets("data").Cells(iterator, 4)
turns into

Code:
Sheets("data").Cells(iterator, 4) = Sheets("nindex").Cells(1, 2)
... really just switching the sides of the equal sign. Just trying to do this most efficiently, as opposed to going line by line. A search+replace wouldn't work.. so just figured someone out here might have a way to accomplish this by avoiding line by line changes?

Thanks much

pg