0

I just can't get on with the following problem and hope someone knows a solution.

The following vba command does not work reliably because the entries of column AR use the concatenate command. The result is (depending on outputs of the concatenate command) that I often get an error message that I can't paste this here because the copy area and the paste area are not the same size.

ersteZielDatei.Sheets(1).Range("AR" & Zeilennummer & ":AR" & Zeilennummer + 199).Copy NeueTabelle.Sheets(1).Range("C2").PasteSpecial xlPasteValues

I have searched around a lot but have not found anything.

BigBen
  • 46,229
  • 7
  • 24
  • 40
Thomas Schreiber
  • 1
  • 1
    `NeueTabllle.Sheets(1).Range("C2").Resize(200).Value = ersteZielDatei.Sheets(1).Range("AR" & Zeilennummer & ":AR" & Zeilennummer + 199).Value`. Skip the clipboard, and assign the `.Value` directly. – BigBen Feb 02 '23 at 17:58

0 Answers0