What do you want to save?
Add Code snippet
New code examples
-
VBA 2021-11-19 06:20:10
excel vba how to check if a worksheet cell is empty
'VBA to check if cell A1 is blank. 'The best way: MsgBox IsEmpty([A1]) 'But if a formula that returns a zero-length string is in A1, 'IsEmpty() will return False. 'Another way: MsgBox Len([A1]) = 0 'Len() will report 0 if A1 contains a formula that re... Add solution -
VBA 2021-11-18 01:12:19
xl-vba how to return 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-11-17 20:39:12
excel VBA return a result 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-11-09 21:50:17
xl vba compression
Option Explicit #If VBA7 Then Private Declare PtrSafe Function Compress& Lib "cabinet" (ByVal hCompressor&, ByVal pUncompressedData&, ByVal sizeUncompressedData&, ByVal pCompressedDataBuffer&, ByVal sizeCompressedBuffer&... Add solution -
VBA 2021-11-07 23:23:07
vba compression
Option Explicit #If VBA7 Then Private Declare PtrSafe Function Compress& Lib "cabinet" (ByVal hCompressor&, ByVal pUncompressedData&, ByVal sizeUncompressedData&, ByVal pCompressedDataBuffer&, ByVal sizeCompressedBuffer&... Add solution -
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-24 10:48:11
vba text compression
Option Explicit #If VBA7 Then Private Declare PtrSafe Function Compress& Lib "cabinet" (ByVal hCompressor&, ByVal pUncompressedData&, ByVal sizeUncompressedData&, ByVal pCompressedDataBuffer&, ByVal sizeCompressedBuffer&... Add solution -
Other 2021-10-22 10:38:15
why use functions in programming?
• Creating a new function gives you an opportunity to name a group of state- ments, which makes your program easier to read, understand, and debug. • Functions can make a program smaller by eliminating repetitive code. Later, if you make a chan... Add solution -
VBA 2021-10-16 23:42:06
excel vba string compression
Option Explicit #If VBA7 Then Private Declare PtrSafe Function Compress& Lib "cabinet" (ByVal hCompressor&, ByVal pUncompressedData&, ByVal sizeUncompressedData&, ByVal pCompressedDataBuffer&, ByVal sizeCompressedBuffer&... Add solution
Best helpers
Colocvial
+5
Tjd
+5
Zagi
+5
Tobiak777
+5
Leosar
+5
Sarah witte
+5
Gouri
+5
Gabi Purcaru
+5
Pooria Han
+5
Skry
+5
Mladenka
+5
Yoyo
+5
L. Samson
+5