VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)

05-07-2017, 04:51 AM

Forum2000s Forum2000s is offline

Windows 7 32bit VBA Newbie (Trying to write a code to copy and paste info from one sheet to another)

Office 2010 32bit

Novice

Join Date: May 2017

Posts: 2

Quote:

Originally Posted by NoSparks

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!

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy a row and paste the row into another sheet more then one time:macro	waqar1239	Excel Programming	1	04-07-2017 09:57 AM
How to copy excel sheet withe HEADER and Paste into new sheet?	cloudforgiven	Excel Programming	6	01-05-2017 07:30 PM
Open csv files & copy and paste info into master file	gbaker	Outlook	9	04-22-2016 11:02 PM
copy checkbox string and paste it in excel sheet	MOHAMMEDSALMAN	Excel Programming	7	10-29-2015 03:50 AM
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet.	rogcar75	Excel	0	08-12-2014 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:22 AM.