Posts by Devinicius • 1 point

• -1

  votes

  0

  answers

  14

  views

  Q: How to convert a decimal number into an integer in an SQL query

  I am making a query in SQL in my database and is returning values in decimal. Is there a function to round the values or turn them into integers?

  sql dbeaver

  asked 3 years, 3 months ago Devinicius 1

• -1

  votes

  0

  answers

  14

  views

  Q: Colorize a line if a condition is true

  Public Sub Worksheet_Change(ByVal Target As Excel.Range) Set range1 = Range("B2:B20") For Each cell In range1 If cell = "Recente" Then With cell.Interior .Pattern = xlSolid .PatternColorIndex =…

  excel-vba

  asked 3 years, 3 months ago Devinicius 1