What do you want to save?
Add Code snippet
New code examples
-
VBA 2021-11-04 23:39:09
vba word pdf table to excel
Sub ImportPDFTable() Dim wdDoc As Object Dim wdFileName As Variant Dim wrd As Object Dim ApplicationIsRunning As Object Dim IsWordRunning As Boolean Dim TableNo As Integer Dim iRow As Long, iCol As Integer, iCount As Integer wdFileName = Application.... Add solution -
VBA 2021-11-04 12:48:15
excel vba how to continue on next line
'VBA uses the combination of a Space character AND an Underscore to 'continue a line of code to the next line. 'For example: MyVariable = ThisWorkbook.Worksheets("Sheet1").Range("A1").Value & _ ThisWorkbook.Workshee... Add solution -
VBA 2021-10-31 06:56:08
excel vba copy range with filter
Sub ExtractVisibleCells() Dim wsSource, wsExtract As Worksheet Set wsSource = ThisWorkbook.Sheets("Source Data") Set wsExtract = ThisWorkbook.Sheets("Filtered") wsSource.Range("A1:A10").SpecialCells(xlCellT... Add solution -
Go 2021-10-29 19:30:24
give a cell a bottom border google script
var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var cell = sheet.getRange("B2"); // Sets borders on the top and bottom, but leaves the left and right unchanged // Also sets the color to "red", and the bo... Add solution -
Other 2021-10-26 08:37:14
app script comparison existing data
function getNewData() { //deleting triggers var triggers = ScriptApp.getProjectTriggers(); for (var i = 0; i < triggers.length; i++) { if (triggers[i].getHandlerFunction()=='getNewData'){ ScriptApp.deleteTrigger(triggers[i]); } ... Add solution -
VBA 2021-10-26 04:54:20
vba function sheet exists
'VBA function to test if a sheet exists in the active workbook: Function IsSheet(n$) As Boolean IsSheet = Not IsError(Evaluate(n & "!a1")) End Function '----------------------------------------------------------------------- 'Same thi... Add solution
Best helpers
Ranking is empty