Thread: VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)
View Single Post
 
Old 05-07-2017, 04:51 AM
Forum2000s Forum2000s is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: May 2017
Posts: 2
Forum2000s is on a distinguished road
Default
Quote:
Originally Posted by NoSparks View Post
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
Awesome! I was so frustrated with this.

Thank you for the help!
Reply With Quote