Hello

Somone knows how can i set a range (with the same property an
actions) ,defining the number of cell but not defining where it will b
located?
eg: a window (2X2) wich the cell(1,1) is fixed "my name"

I am trying this

Function windowx(cellx) As Range

cellx.Value = "myname"

Set windowx = Range(cellx, celx.Offset(1, 1))

End Function

and i am getting " object required"

All help wiil be welcome

thank yo

--
Message posted from http://www.ExcelForum.com