?
Solved

Paste Active cell data till the end within defined NamedRange

Posted on 2014-01-14
5
Medium Priority
?
334 Views
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
0
Comment
Question by:satmisha
[X]
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
5 Comments
 
LVL 52

Expert Comment

by:Rgonzo1971
ID: 39779004
HI,

pls try

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

Open in new window

Regards
0
 

Author Comment

by:satmisha
ID: 39779017
Thanx.

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

Accepted Solution

by:
Rgonzo1971 earned 540 total points
ID: 39779019
HI,

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

Regards
0
 

Author Comment

by:satmisha
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.
0
 

Author Closing Comment

by:satmisha
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
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
New style of hardware planning for Microsoft Exchange server.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 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