View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alvin Kuiper alvin Kuiper is offline
external usenet poster
 
Posts: 175
Default Variable Question

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