Thread: VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)
View Single Post
 
Old 05-05-2017, 07: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
You're not fully qualifying things in telling Excel what to work with. Try like this...
Code:
erw = Sheets("QADatabase").Cells(1, 1).CurrentRegion.Rows.Count + 1
Sheets("QADatabase").Cells(erw, 1) = Sheets("QAForm").Range("B3").Value
'etc
Reply With Quote