Thread: VBA code If... then... copy... from one sheet to another
View Single Post
 
Old 06-28-2017, 10:39 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
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.
Reply With Quote