Posts by Andre Gorgonio • 16 points

• 0

  votes

  2

  answers

  9649

  views

  A: Automatically fill cells in excel using VBA

  Try to define a range limit and from that subtract the values, something like that: Sub preencherCameras() Dim Limite, Linha, Coluna As Integer Limite = 4 Linha = Application.ActiveCell.Row 'Linha…

  excel loop excel-vba do-while

  answered 7 years, 2 months ago Andre Gorgonio 16

• 0

  votes

  1

  answer

  236

  views

  A: Upload image in Excel from a directory

  Try it with these adjustments: Public Function getImage(ByVal sCode As String) As String Dim sFile As String Dim oSheet As Worksheet Dim oCell As Range 'Declaração com nome diferente do código Dim…

  excel-vba

  answered 7 years, 2 months ago Andre Gorgonio 16