What do you want to save?
Add Code snippet
New code examples in category VBA
-
Kiran Amaravati 2021-09-18 21:42:04
count number of cell ina range vba
Sub DisplayColumnCount() Dim iAreaCount As Integer Dim i As Integer Worksheets("Sheet1").Activate iAreaCount = Selection.Areas.Count If iAreaCount <= 1 Then MsgBox "The selection contains " &... Add solution -
Irina Avram 2021-09-18 15:37:03
excel vba copy values range to another range
Sub TransferValuesOnly() Worksheets("Sheet1").Range("A1:Z100").Copy 'PasteSpecial Values Only Worksheets("Sheet2").Range("A1").PasteSpecial Paste:=xlPasteValues 'Clear Clipboard (removes "marching ants&... Add solution -
Woodgate 2021-09-18 13:58:02
vba for next
For i = 1 to 100 'Code here is executed 100 times. Next ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 'Notes: The For loop is terminated with the 'Next' keyword. There is no need ' to include the counter variable a... Add solution -
Cloud_nine 2021-09-18 10:42:02
excel vba add sheet
Sheets.Add Sheets.Add After:=Sheets("Input") Sheets.Add After:=Sheets(1) Sheets.Add Before:=Sheets(2) Sheets.Add.Name = "NewSheet" ' Add sheet with name Sheets.Add After:=Sheets(Sheets.Count) ' To end of Workbook Sheets.Add(B... Add solution -
EricMPastore 2021-09-18 08:58:02
office wait milliseconds
'VBA function to delay execution: Function Delay(ms) Delay = Timer + ms / 1000 While Timer < Delay: DoEvents: Wend End Function 'To delay program execution for 250 milliseconds: Delay 250 '----------------------------------------------------... Add solution