Question: how to copy multiple non adjacent cells in excel vba?
Answer: Copy the data from sheet1 to sheet2 to exactly the came cell addresses (not very useful) Copy the non-continuous data from sheet1 to sheet2 in adjacent columns. Copy the non-adjacent data from sheet1 to sheet2 in adjacent rows one below the other.