Can I use a variable in a Range statement

[Alfarata]

I have tried to use a variable in this Range satement but I get a Select Method of Range Class Failed. I need to reformat this as I move data.
X is a changing row variable.
Any help would be greatly appreciated
Thanks
Bill
Dim Temp as String
Temp = "O" & X

If TopInches < 10 Then
Range(Temp).Select
Selection.NumberFormat = "## ""' "" 0 ##/##"
Else
Range(Temp).Select
Selection.NumberFormat = "## ""' "" #0 ##/##"
End If

[malik641]

You mean something like this?

Please Login or Register  to view this content.

[Alfarata]

Thanks that worked

any thoughts on the formating if TopInches is >10 then I was going to format using this:Range(Temp).NumberFormat = "## ""' "" #0 ##/##"

But I get the wrong result 161' 03/4
It shold be 16' 10 3/4

Thanks bill