How To Copy/Paste Partial Row

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How To Copy/Paste Partial Row

FAQ

Thread Tools

Display Modes

04-25-2021, 02:43 AM

gibra

Windows 10 How To Copy/Paste Partial Row

Office 2019

Novice

Join Date: Mar 2021

Posts: 8

I honestly don't understand what you are trying to do, and why you want to paste the data into the Sheet1 sheet.

Your error is that you paste an entire row into a single cell.

It would seem that it is enough to remove EntireRow from the instruction, that is:

Code:

c.Copy Destination: = ws1.Cells (x, "B")

but the result is so strange that I doubt it is the desired one.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cut/copy and paste won't paste	DennisWG	Word	1	03-13-2020 12:36 PM
VBA copy/paste	Urraco	Excel Programming	3	05-14-2018 03:59 AM
When I copy&paste a second copy appears that can't be edited	makeo22	Word	3	04-26-2017 07:09 PM
Copy n Paste	seimeinokigen	Excel	2	04-16-2016 09:31 AM
Paste Special: Copy and Paste Formatting Only?	tinfanide	Word	6	03-06-2013 12:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:30 AM.