Posts by leal32b • 11 points

• 0

  votes

  1

  answer

  48

  views

  A: VBA Before Close

  Good night, Leonardo. See if the code below helps, please: Private Sub Workbook_BeforeClose(Cancel As Boolean) Cancel = MsgBox("Você enviou os dados?", vbQuestion + vbYesNo) = vbNo End Sub…

  excel vba powerpoint

  answered 4 years ago leal32b 11

• 1

  votes

  1

  answer

  184

  views

  A: How to print only the first page

  Good afternoon, Lucas. Add the line From:=1, To:=1, as the example below: Sub Macro1() ChDir "C:\Users\user\Desktop" ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _…

  excel vba

  answered 5 years ago leal32b 11

• 0

  votes

  2

  answers

  374

  views

  A: SUMS with reference within the array

  Use the formula below, where "C1" and "D1" are the cells that should contain the dynamic values. After pasting the formula confirm with Ctrl+Shift+Enter, for being a vector formula.…

  array excel matrix

  answered 5 years, 7 months ago leal32b 11