As you have it, cell is a range. HTH Otto
"alvin Kuiper" <alvinKuiper@discussions.microsoft.com> wrote in message
news:9C8534BF-28AC-4A80-AAF8-1E7DCD0F4A7D@microsoft.com...
> Hi
> If i have this
> With Worksheets("Ark1")
> Set cell = .Cells(Rows.Count, 1).End(xlUp)
> End With
> If Not IsEmpty(cell) Then Set cell = cell(2)
> cell.Value = antal
>
> What type is Cell as vaiable
>
> Regards alvin
>
Bookmarks