Copy & paste 2 ranges of cells

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Copy & paste 2 ranges of cells

FAQ

Thread Tools

Display Modes

11-28-2018, 06:15 PM

NoSparks

Windows 7 64bit Copy & paste 2 ranges of cells

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

@trevorc
you've still neglected to mention:
- the name of the sheet the Worksheet_Change event would be used on
- the column or range of cells the Worksheet_Change event would be restricted to
- the location (ie: starting column) where Sheets("Customer").Range("I" & t & ":L" & t) would be copied to
- the location (ie: starting column) where Sheets("Customer").Range("Y" & t & ":AH" & t) would be copied to

Posting a sample workbook would be to your advantage.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy two separate ranges from another workbook	kevinbradley57	Excel Programming	11	07-25-2018 01:51 PM
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet	CaptainRetired	Excel Programming	18	01-04-2018 07:22 PM
Copy/Paste EXCEL cells as pic in WORD	A_Lau	Drawing and Graphics	3	12-19-2014 06:57 AM
Can you copy & paste cells across worksheets and preserve reference to worksheet?	New Daddy	Excel	2	11-27-2013 07:19 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 01:55 AM.