Thanks
Alvin

"Otto Moehrbach" wrote:

> 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
> >
>
>
>