Simple copy question

wbendermd · #1 11-15-2018, 06:57 AM

I am working in a spreadsheet where I use the "end" "down" buttons to move to the next cell containing data. I then wish to copy that cell and a single cell below it to a specific location. How do I create the copy range in a macro to automate this repetitive process? I think it is something very simple I just can't remember.

NoSparks · #2 11-15-2018, 07:37 AM

Quote:

I then wish to copy that cell and a single cell below it

ActiveCell.Resize(2).Copy

wbendermd · #3 11-15-2018, 08:00 AM

Thank you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A simple math question	markg2	Excel	6	03-01-2014 11:10 AM
Simple Mail Merge Question	Ethanflux	Mail Merge	1	09-29-2013 07:21 PM
Simple question about line space	danezcou3	Word	1	04-21-2013 05:38 AM
Simple Question, difficult task...	Jshopping	Word	4	01-19-2011 03:04 PM
Simple Envelope Question....	cmcneill	Word	0	08-17-2009 05:12 PM