Variable Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Wow not bad at all
Thanks
Alvin


Bob Phillips said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New value in a cell 4
VBA set thick borders around non empty cells in range 0
Run two macros for two different sheets 11
Lookup Formula Problem 2
Vaiable Help in VBA 5
Array with many cells from a row but not in order or together 11
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Please help with this chart 1

Back
Top