输入表格，Excel，VBA复制输入并粘贴到另一个工作表中

是的，您是正确的，通常最好避免在VBA代码中使用.Select和.Paste，因为它们需要花费较长的时间来处理，通常是不必要的。在您的情况下，使用for循环会更容易，该循环遍历一系列单元格并将它们复制到另一张纸上。这使您可以检查单元格是否包含任何东西，如果它不包含任何东西，则可以跳过它。这是一个例子：

Sub CopyCells()

    Dim rng As Range, cell As Range, copyToCell As Range

    Set rng = ThisWorkbook.Sheets("Entry").Range("A1:A10") 'This is the range you want to copy from
    Set copyToCell = ThisWorkbook.Sheets("inputs").Range("A1") 'This is the first cell in the range you want to copy to

    For Each cell In rng
        If cell.Value <> "" Then 'Only copy from cells that are not blank
            copyToCell.Value = cell.Value
            Set copyToCell = copyToCell.Offset(0, 1) 'Move the copy to cell over by one column (or by row if you prefer)
        End If
    Next cell

End Sub