Set variable to ActiveCell

[mjpst6]

Re: Cell value to VB variable

Is there a way to set the active cell value as the variable value instead of specifying which cell.

I already have the active cell part down but don't know the code to make it the variable value.

Thanks in advance for any help

 

[Scott Huish]

Re: Cell value to VB variable

y = ActiveCell.Value

 

[mjpst6]

Re: Cell value to VB variable

Thanks Hotpepper,

My dumb mistake was I forgot that text was String so I had what you said to have but had the definition wrong.

Thanks for the help nonetheless,

 

[Zack Barresse]

Hi,

Unless some specific reason, it's generally and usually a good habit to stay away from using ActiveCell or Selection, in Standard Routines anyway. There's not much need to select cells or activate them in procedures. They have their benefits, but not usually. If you want to post your code an a representative sample, an improved solution may present itself.