Hi
Well that depends
Do you only want to select the cell(u4) if so then you have to activate the
sheet before you select the cell
If there is a value in the cell that you would want to use then you can make
it a variable
Just let me now what you are planning to do with the cell first

thanks hope it helped

"Alex" wrote:

How would I make it a variable? I am rather new to this...

"CmK" wrote:

What i remember you have the activate the sheet before you select the cell
This formula
ActiveWorkbook.Sheet1.Range.Value=("u4").Select
Just wont select the cell
if you just want the value in thet cell u can make it a variable

Hope this helped

thanks

"Alex" wrote:

I am trying to select a range that is defined in a cell on sheet 1. this is
what i have but am getting no place with it. any ideas?

ActiveWorkbook.Sheet1.Range.Value=("u4").Select