hmm... I shouldve looked at your code more...
u are passing in variables to be set?
u should be using a function to return values...
really for what u are doing.. I would do this
since you are declaring N & M in the gen dec section.. you dont need to pass them in at all....VB Code:
Dim N As Integer, M As Integer Sub CopyInteger() XLRead XLPrint End Sub Sub XLRead() N = Cells(1, 2).Value M = Cells(2, 2).Value End Sub Sub XLPrint() Cells(1, 3).Value = N Cells(2, 3).Value = M End Sub




Reply With Quote