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

As you have it, cell is a range. HTH Otto
"alvin Kuiper" wrote in message
...
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

Thanks
Alvin

"Otto Moehrbach" wrote:

As you have it, cell is a range. HTH Otto
"alvin Kuiper" wrote in message
...
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

You can easily find out. Step through the code, and after setting the value,
drag a copy of cell into the Watch window and it will tell you in there.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"alvin Kuiper" wrote in message
...
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

Wow not bad at all
Thanks
Alvin


"Bob Phillips" wrote:

You can easily find out. Step through the code, and after setting the value,
drag a copy of cell into the Watch window and it will tell you in there.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"alvin Kuiper" wrote in message
...
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