Thread: assign variable to a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alberto Ast[_2_] Alberto Ast[_2_] is offline
external usenet poster
  
Posts: 181
Default assign variable to a range
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.
Reply With QuoteReply With Quote