switch sides of =

[pgag45]

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

Sheets("nindex").Cells(1, 2) = Sheets("data").Cells(iterator, 4)

turns into

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

[RobDog888]

If you know the region of cells you can copy/paste the region from one sheet to another without any looping.

[pgag45]

yeah.. I'm trying to put it in a jarbled up excel sheet, that pretty much has to go cell by cell, which doesn't have much order to it.