Thanks, J.E.; good catch.

Regards,

Vasant.

"J.E. McGimpsey" wrote in message
...
Note that this will fail if Sheet Team Data is not the active sheet
since Range("X2") is not qualified


In article ,
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote:

Sheets("Team Data").Range(Range("X2").Value & "4") = TextBox1.Value