L
Legacy 447816
Guest
Hello everyone. I am new here so apologies if I have asked a question that has already been answered.
I have a bit of a dilemma and I am not finding anything able to explain what I am doing wrong. I am currently working on a work project in which I need to separate and re-sort a report based on very custom fields that does not have a built in Excel sort function to my knowledge.
I have it working, but it is very slow. The reason being is because the only way I have gotten it to work so far is to loop through each cell in the row and write it to the temp sheet one by one.
What I am attempting to do (and it won't work no matter what I try) is to instead move the entire row to the temp sheet all at once, ending at the last column with data because if I don't, that attempt is even slower. I also attempted to add all of the values to an array and transfer them that way using For Each, but, again, even slower. We handle data sets over 100,000 in many cases so, I am trying to find the most efficient way possible.
I keep getting "Invalid Qualifier" on this line and can't figure out why. I also cannot find a single resource that explains the syntax needed to do the above.
I am simply trying to set the value on the throwaway sheet's current row, (SpecCurCopyRow) to the value on the original sheet, up to just the last column of data.
SpecSuffSheet.Range(Cells(SpecCurCopyRow, 1), Cells(SpecCurCopyRow, SpecCurCopyRow.End(xlRight))) _
= OurWorksheet.Range(Cells(CurRow, 1), Cells(CurRow, CurRow.End(xlRight)))
Thanks!
I have a bit of a dilemma and I am not finding anything able to explain what I am doing wrong. I am currently working on a work project in which I need to separate and re-sort a report based on very custom fields that does not have a built in Excel sort function to my knowledge.
I have it working, but it is very slow. The reason being is because the only way I have gotten it to work so far is to loop through each cell in the row and write it to the temp sheet one by one.
What I am attempting to do (and it won't work no matter what I try) is to instead move the entire row to the temp sheet all at once, ending at the last column with data because if I don't, that attempt is even slower. I also attempted to add all of the values to an array and transfer them that way using For Each, but, again, even slower. We handle data sets over 100,000 in many cases so, I am trying to find the most efficient way possible.
I keep getting "Invalid Qualifier" on this line and can't figure out why. I also cannot find a single resource that explains the syntax needed to do the above.
I am simply trying to set the value on the throwaway sheet's current row, (SpecCurCopyRow) to the value on the original sheet, up to just the last column of data.
SpecSuffSheet.Range(Cells(SpecCurCopyRow, 1), Cells(SpecCurCopyRow, SpecCurCopyRow.End(xlRight))) _
= OurWorksheet.Range(Cells(CurRow, 1), Cells(CurRow, CurRow.End(xlRight)))
Thanks!