refedit to select single cell not range

[Steve Manning]

Hello is there a way to have refedit select the contents of only a single cell? I have a macro that seems to crash because I'm trying to enter (refedit.text) into a single cell. I think it is crashing because the refedit returns a range.
Thanks for any ideas.
Steve

 

[Damon Ostrander]

Hi Steve,

The problem is not that refedit returns a Range. Even a single cell IS a Range object, albeit a special case. The .Text (and .Value) properties of the Refedit control are not cells or Range objects, they are simply text strings identifying the address of the range. If you want the Range object corresponding to the address string returned by the Refedit object you must use the Range property. For example:

Range(RefEdit1.Text).Value= "Hi there"

puts the string "Hi there" into the cell or cells defined by RefEdit1. If you use the RefEdit to select multiple cells and want the string to be put only in the first cell of the range you can do this:

Range(RefEdit1.Text).Cells(1).Value = "Hi there"

I hope this helps.