Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Range.value(error)
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) --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Range.value(error)
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 vikrampn wrote: 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) --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting to xlsx error | New Users to Excel | |||
I get a Format error when converting my yahoo contacts to CSV file | Excel Discussion (Misc queries) | |||
Converting a Grid (or range) of Data to a List | Excel Worksheet Functions | |||
help converting text to range object | Excel Programming | |||
Converting a range to string | Excel Programming |