Re: $$Excel-Macros$$ multiple parameters function VBA

2012-12-05 Thread Paul Schreiner
--- From: pawel lupinski To: "excel-macros@googlegroups.com" Sent: Wed, December 5, 2012 8:33:05 AM Subject: Re: $$Excel-Macros$$ multiple parameters function VBA Paul,   Thanks for reply. Yes I have couple problems :) 1. file is too big to send. 2. I've fo

Re: $$Excel-Macros$$ multiple parameters function VBA

2012-12-05 Thread pawel lupinski
y, December 5, 2012 12:50 PM Subject: Re: $$Excel-Macros$$ multiple parameters function VBA Pawel, We've got a couple of problems here. (I guess that's why you came to US, right?) The first problem is going to be that will need help understanding your data. If you only want to check

Re: $$Excel-Macros$$ multiple parameters function VBA

2012-12-05 Thread Paul Schreiner
Pawel, We've got a couple of problems here. (I guess that's why you came to US, right?) The first problem is going to be that will need help understanding your data. If you only want to check specific columns (C, F, Z, AC) then we can do that. But if you want to look in the entire range, say:

Re: $$Excel-Macros$$ multiple parameters function VBA

2012-12-05 Thread pawel lupinski
ok I've got it   Function XOf(ParamArray Nums() As Variant) As Variant '' ' Add up the numbers in Nums ''     Dim N As Long     Dim D As Double     For N = LBound(Nums) To UBound(Nums)     If Nums(N) < 0 Then     Exit F