[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Paste Active cell data till the end within defined NamedRange

Posted on 2014-01-14
5
Medium Priority
?
342 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
  • 3
  • 2
5 Comments
 
LVL 54

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 54

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

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
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…

834 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