What do you want to save?
Add Code snippet
New code examples
-
VBA 2021-10-08 00:16:03
how to attached to outlook only two sheet from workbook in excel vba
Dim lX As Long Dim aryWorksheets() As Variant Dim sWorksheets As String Dim iAnswer As VbMsgBoxResult For lX = 1 To ActiveWindow.SelectedSheets.Count ReDim Preserve aryWorksheets(1 To lX) aryWorksheets(lX) = Active... Add solution -
Other 2021-09-25 00:15:05
Auto Size Listbox Columns
Function ControlsResizeColumns(LBox As MSForms.Control, Optional ResizeListbox As Boolean) Application.ScreenUpdating = False Dim ws As Worksheet If sheetExists("ListboxColumnWidth", ThisWorkbook) = False Then Set ws = ThisWorkb... Add solution -
VBA 2021-08-26 22:50:02
vba redim preserve
Dim MyArray() As String ReDim MyArray(1) MyArray(0) = "zero" MyArray(1) = "one" ReDim Preserve MyArray(2) MyArray(2) = "two" MsgBox MyArray(0) & " " & MyArray(1) & " " & MyArray(2) Add solution