Converting Range.value(error)

  • Thread starter Thread starter vikrampn
  • Start date Start date
V

vikrampn

Could some one tell me if this is correct. I am getting a run Time
error on the second line


Dim intNumOfProducts as Integer

intNumOfProducts = CInt(Range("B1").Value)
 
It looks ok to me, but what's in B1?

maybe:

If IsNumeric(Range("b1").Value) Then
intnumofproducts = CInt(Range("b1").Value)
Else
MsgBox "It's not a number! " & Range("b1").Value
End If
 
You must log in or register to reply here.

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

Displaying cell contents 1
Access #Error & Excel Pivot 0
val() is not work in my code 1
Can't get soap client to connect in Excel 2010 64 bit 0
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 2
Arrey VAriable - How to initialise 1
Combining Procedures into Loop 3
fighting the type mismatch error 2

Back
Top