[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Paste Active cell data till the end within defined NamedRange

Posted on 2014-01-14
Medium Priority
Last Modified: 2014-01-14
Hi Expert,

Want to paste active cell data within NamedRange down.

I have Named Range of 10 columns lets "Name1".
I type "ABC" on 5th column.
I want to paste value "ABC" till 10th column with in the named range "Name1".

I have tried with below code but no success any help will be appriciated.

Range(ActiveCell, Cells(Rows.Count, ActiveCell.Column + 1).End(xlDown).Offset(, -1)).Value = ActiveCell.Value
Question by:satmisha
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 53

Expert Comment

ID: 39779004

pls try

Range(ActiveCell, ActiveCell.End(xlDown).Row, ActiveCell.End(xlToRight).Column).Value = ActiveCell.Value

Open in new window


Author Comment

ID: 39779017

"It says that wrong number of arguments and invalid property assignment."
LVL 53

Accepted Solution

Rgonzo1971 earned 540 total points
ID: 39779019

pls try

Range(ActiveCell, Cells(Range("Name1").Rows.Count + Range("Name1").Row - 1, Range("Name1").Columns.Count + Range("Name1").Column - 1)).Value = ActiveCell.Value

Open in new window


Author Comment

ID: 39779090
you rock bro.

Hope in days to come i'll be quick as you, actually I just started with vba.

Anyways! Thanks a lot.

Author Closing Comment

ID: 39779096
Damn good solution Pal.

Being a beginner if u cd suggest me few pointers\topics to learn then it wd be a gr8 help for me.

Thnx a ton again. bi

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question