Relative Content

Tag Archive for arrayssortingconditional-statementscopypaste

conditional copy and paste line by line with vba

I could copy and paste cell contents (which can includes new lines with alt+enter) respectively and separately to another column in another sheet with the below code until i added bolded part into the code.
My aim is to sort cell content if there in ‘NONE’ string in the C column. But i receive error 1004 at this line.

conditional copy and paste line by line wtih vba

I could copy and paste cell contents (which can includes new lines with alt+enter) respectively and separately to another column in another sheet with the below code until i added bolded part into the code.
My aim is to sort cell content if there in ‘NONE’ string in the C column. But i receive error 1004 at this line.