assign variable to a range

A

Alberto Ast

I have saved an activecell value to a variable

xlastdev = ActiveCell.Value

Then have saved an activecell adress to anotehr variable

xnextDev = ActiveCell.Address

I want to assign the last value to the next address

Range(xnextDev).Value = xlastdev

But it does not work... it fail at the last command.
 
J

Jacob Skaria

--It does work..Try the below code in Step Into mode (use F8 instead of F5)

--You are writing the stored value to the same cell

xlastdev = ActiveCell.Value
xnextDev = ActiveCell.Address

Range(xnextDev).ClearContents
Msgbox "Cleared"

Range(xnextDev).Value = xlastdev

--If you are looking to write to the next cell try
Range(xnextDev).OffSet(1) = xlastdev


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set variable to active cell address 7
Assign Selection to a Variable 2
My code need to go on a diet 10
Unable to view variable 5
InputBox - finding the input in a range 2
Using a variable in an If statement 7
Assign variable value across files 1
Assign copied range to a variable 3

Top