What do you want to save?
Add Code snippet
New code examples
-
VBA 2021-11-06 13:20:24
excelvba return a result from a function
'In VBA, you assign the return value to the name of the function. 'This is different from many languages that use the 'return' keyword: Function Yesterday() As Date Yesterday = Date() - 1 End Function 'VBA functions can be called from other VBA code: ... Add solution -
VBA 2021-10-30 01:48:03
excel how to return a result from a VBA function
'In VBA, you assign the return value to the name of the function. 'This is different from many languages that use the 'return' keyword: Function Yesterday() As Date Yesterday = Date() - 1 End Function 'VBA functions can be called from other VBA code: ... Add solution -
VBA 2021-10-18 19:05:10
vba string array
'In VBA a dynamic string array is declared in the following ways: Dim strArr1() As String Dim strArr2$() 'Neither declaration style is prefered. They are exactly equivalent. 'Both ways above produce a dynamic array, which means that the exact size of '... Add solution -
PHP 2021-10-13 07:18:10
add values to array dynamically php
There are quite a few ways to work with dynamic arrays in PHP. Initialise an array: $array = array(); Add to an array: $array[] = "item"; // for your $arr1 $array[$key] = "item"; // for your $arr2 array_push($array, "item"... Add solution -
C++ 2021-10-07 03:50:02
deque c++
/* A deque is a dynamic array whose size can be efficiently changed at both ends of the array. Like a vector, a deque provides the functions push_back and pop_back, but it also includes the functions push_front and pop_front. */ deque<int> d; d.p... Add solution -
Java 2021-10-04 09:19:04
Implement the Bubble sort algorithm on the following ArrayList
import java.util.ArrayList; public class Sort{ private static ArrayList<String> list = new ArrayList<String>(); public static ArrayList<String> sortByName(String [] input) { String temp; for (int i=0; i< inpu... Add solution -
VBA 2021-09-27 22:01:06
xl vba udf translate text
'VBA function (extremely fast) to force an array column 'to ONLY alpha-numeric characters (with spaces): Function ForceArrayColumnAlphaNumeric(v, Optional col& = 1) Dim i&, j&, p&, max&, t& Dim b() As Byte, res() As Byte,... Add solution -
Other 2021-09-27 12:26:04
clear array vba
'In VBA to reset a dynamic array of Longs or Doubles to all zeros, the simplest way 'is to use the Redim() function. It's also extremely fast, roughly four times 'faster than iterating over the array to set each element. Sub Test_ArrayZeroing() Dim ... Add solution