Paste Active cell data till the end within defined NamedRange

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
satmishaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rgonzo1971Connect With a Mentor Commented:
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
 
Rgonzo1971Commented:
HI,

pls try

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

Open in new window

Regards
0
 
satmishaAuthor Commented:
Thanx.

"It says that wrong number of arguments and invalid property assignment."
0
 
satmishaAuthor Commented:
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
 
satmishaAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.