Copy two separate ranges from another workbook

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Copy two separate ranges from another workbook

FAQ

Thread Tools

Display Modes

07-25-2018, 09:16 AM

kevinbradley57 kevinbradley57 is offline

Windows 7 64bit Copy two separate ranges from another workbook

Office 2010 64bit

Advanced Beginner

Join Date: Jul 2017

Posts: 89

kevinbradley57 is on a distinguished road

Thanks, NoSparks. The first double quotes were slanted -- no idea how I did that. However, now I get this run-time error: Method 'Range' of object' _Global' failed.

Here's the code:

Code:

Sub Difference()
Lastrow = Range("H" & Rows.Count).End(xlUp).Row
Range("H2").FormulaR1C1 = "RC[-2]-RC[-3]"
Range("H2").AutoFill Destination:=Range("H2:H") & Lastrow
ActiveSheet.AutoFilterMode = False
Application.ScreenUpdating = True
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy data as well as formatting from one workbook to another.	LearnerExcel	Excel	1	03-10-2018 01:35 PM
Copy from one workbook to another	MartinExcel11	Excel Programming	1	03-28-2017 09:49 AM
Take String of numbers, expand ranges, sort, then compress back into ranges	AustinBrister	Word VBA	19	08-22-2016 05:18 PM
How to make a shared workbook and allow user to edit ranges	prdecina	Excel	1	07-25-2016 11:42 PM
Storing and retreiving text from a separate workbook	Benjamin92	Excel Programming	4	03-08-2015 04:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:13 PM.