local

This May and June, the ModelOff Team is traveling around APAC to hold local networking events - and you are invited to join the celebrations! Six FREE drinks networking events will be held in Melbourne (May 26), Sydney (May 27), Singapore (June 9), Bangalore (June 10), Hong Kong (June 11) and...

Sub GetCSV() Const strFilename = "MINUTE.csv" Dim wshList As Worksheet Dim wshTarget As Worksheet Dim r As Long Dim m As Long Dim objXML As Object Dim f As Long Dim arrResp() As Byte Dim strWebfile As String Dim strLocalFile As String Dim strIP As...

Hi, I'm coding in excel 2010 and I was wondering if there is a way to create a variable that is local to a for loop. The equivalent code in c++ would be: for(int i=0; i<10; i++). I have tried the following and I get the error "Compile Error Expected: =" For i as Integer = 0 To 10 Step 1...

Hi. I have a globally defined named range called "Year" that refers to =Rates!$B$3:$X$3 In a worksheet "Model (1)" I have a B1 cell on which the data validation is set to "Pick from list", and that list is defined as =Year So far so good. I believe that this would not have worked had the...