VBA code If... then... copy... from one sheet to another

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA code If... then... copy... from one sheet to another

FAQ

Thread Tools

Display Modes

06-28-2017, 10:39 AM

NoSparks

Windows 7 64bit VBA code If... then... copy... from one sheet to another

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Worksheets("Commissions").Range(Cells(i, 3)).Value

should be either

Worksheets("Commissions").Cells(i, 3).Value
or
Worksheets("Commissions").Range("C" & i).Value

note that these are how you referred to the other single cells within the procedure.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)	Forum2000s	Excel Programming	2	05-07-2017 04:51 AM
How to copy excel sheet withe HEADER and Paste into new sheet?	cloudforgiven	Excel Programming	6	01-05-2017 07:30 PM
Find matching criterior in sheet 1 and copy to Sheet 2	Auto	Excel Programming	3	03-19-2016 01:41 PM
If two geographical data match in two sheets, copy unique id/code found in one sheet	alliage	Excel	1	09-01-2011 05:23 AM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 PM.