Posts by Akk_Pain • 31 points
7 posts
-
0
votes1
answer40
viewsA: Search for items that are in within a given month of the year
Your code will be something similar to the one below. Change the object columns sheets(A).cells(linha,coluna) by the columns you want. Note: I put two dates: one for the first day of the month and…
-
0
votes1
answer139
viewsA: Cell selection
Good afternoon, I think your code should look like this below: Private Sub RemverRegisto_Click() 'declaração de variáveis dim linha as long dim flag as boolean 'iniciação das variáveis linha=3…
-
0
votes2
answers2677
viewsA: Copy data from one spreadsheet to another
For your code to run faster, instead of copy and paste, you could do: Worksheets("Apontados").cells("A2").value = worksheets("Formulario").cells("B3").value and repeat this syntax for the other…
-
1
votes1
answer143
viewsA: Is there something wrong with that code?
Good morning, I see some mistakes: Erro1: in the declaration of the variables valora, valorB and valorG are as variables of type Variant and only valor2 as STRING. If Valora, Valorb and Valorg are…
-
1
votes2
answers152
viewsA: Vba interacting with IE
Good morning, Try it like this: For Each obj In ie.Document.all if obj.id = "img_684517_43_2506" then obj.Click end if Next
-
1
votes1
answer73
viewsA: VBA / Macro - Cleaning Data
Follow the code you’ll need: Sub dividir_planilha() Dim linha_origem As Integer, coluna_origem As Integer, plan As Integer Dim linha_destino As Integer, coluna_destino As Integer linha_origem = 1…
-
0
votes1
answer115
viewsA: Transpose data in an automatic way
Good afternoon. To "type" you must use the Sendkeys Instruction. This instruction only works with string variables. The code would look like this: Dim strvar as string strvar=cells(1,1).value (sua…