Link to home
Start Free TrialLog in
Avatar of satmisha
satmishaFlag for India

asked on

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
Avatar of Rgonzo1971
Rgonzo1971

HI,

pls try

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

Open in new window

Regards
Avatar of satmisha

ASKER

Thanx.

"It says that wrong number of arguments and invalid property assignment."
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
you rock bro.

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

Anyways! Thanks a lot.
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