-
switch sides of =
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
-
Re: switch sides of =
If you know the region of cells you can copy/paste the region from one sheet to another without any looping.
-
Re: switch sides of =
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.