Home Copy Range Sheet1 Paste in Active Cell Sheet 2
Reply: 0

Copy Range Sheet1 Paste in Active Cell Sheet 2

user3986
1#
user3986 Published in September 19, 2018, 7:06 pm

I'm trying to accomplish the following:

  1. Sheet1: User clicks a button that runs VBA.

  2. Sheet2: VBA selects the first non-blank cell on column D

    Range("D" & Rows.Count).End(xlUp).Offset(1).Select

  3. Sheet1: VBA copies a range of values

    Worksheets("Sheet1").Range("E2:AJ11").Copy

  4. Sheet2: VBA pastes the copied range into the active cell selected previously.

This part where I try pasting into the active cell is not working:

Worksheets("Results").ActiveCell.PasteSpecial xlPasteValues

Does anyone know how to fix this?

Thanks much!

share|improve this question

2 Answers 2

active oldest votes
up vote 0 down vote accepted
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.340372 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO