How To Copy/Paste Partial Row

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

FAQ

Mark Forums Read

Thread Tools

Display Modes

04-24-2021, 10:03 AM

gibra

Windows 10 How To Copy/Paste Partial Row

Office 2019

Novice

Join Date: Mar 2021

Posts: 8

You must always indicate the sheet you intend to work on.
This instruction, does NOT select the range as you think, because it reads the active sheet which is not TCU but is Sheet1.

Code:

For Each c In Range("F15:F" & Cells(Rows.Count, 6).End(xlUp).Row)

so you should be write:

Code:

For Each c In ws.Range("F15:F" & Cells(ws.Rows.Count, 6).End(xlUp).Row)

and so on...

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 09:20 AM.