Code - What's Wrong ?

[sidzega]

Sub Button4_Click()


Dim n As Integer


n = Range("M4").Select


Call LaunchWEST("abx.Ins:& n &", "0", "")

OK so the range is an integer with SIX to Seven Digits and I want it the button to take this string from a Cell and Launch a function LaunchWEST, when the string is selected and completed the button should run:

LaunchWEST("abx.Ins:4879521", "0", "")

I am clueless here peeps.

 

[BiocideJ]

n = Range("M4").Select

should be

n = Range("M4").Value

if you are trying to get the value that is in cell M4.

 

[texasalynn]

I think you had the syntax wrong???

Call LaunchWEST("abx.Ins:" & n & ", " & ", ")

 

[sidzega]

n = Range("M4").Value

gives me Run-time error '6':

Overflow

 

[sidzega]

Sub Button4_Click()


Dim n As Long






n = Range("M4").Text










Call LaunchWEST("abx.Ins:" & n & "", "0", "")


This is working perfectly

THank you people

 

[BiocideJ]

OK, obviously there were a few things I missed. Texaslynn's suggestion is also necessary as well as changing

Dim n as Long
Integers can only be numbers from -32,767 to +32,767


EDIT: NM, I see you got it. Glad it is working.