Posts by Thales Ferraz • 119 points
7 posts
-
0
votes1
answer527
viewsA: Manual filter via VBA with last available values
Abnerka, Below example of VBA code that allows you to differentiate hidden cells from visible cells. Hidden cells get Rowheight = 0 in Excel. Const _ primeiraLinha = 4, _ ultimalinha = 12, _…
-
0
votes2
answers1138
viewsA: How to delete line with information after a blank line in the middle?
From what I understand the phrase "(9 Rows(s) affected)" comes along with the file . TXT’s name "Promessas_diarias_aes_rc_20150304_210000" you are trying to import. From what I understood also this…
-
1
votes2
answers4561
viewsA: Export data from an array to a table using VBA
You can walk through the array items using the FOR command of the VBA. Just always remember that the array starts at position 0 and not at position 1. Sub test() Dim vetor(2) As String vetor(0) =…
-
1
votes2
answers357
viewsA: Restart Numbered VBA Excel Word List
Try to store the last header in a variable and at the time of using the command .ResetOnHigher match with the variable Ex: Dim variavel as long variavel = ultimoHeader.value(exemplo) With…
-
1
votes2
answers3272
viewsA: How to find information from another spreadsheet in Excel
Try using formula =INDIRECT Formula used in this example: CELL B3 table manages.xls =INDIRECT( CONCATENATE( "["; B1; ". xlsx]Plan1! B1"); TRUE)…
excelanswered Thales Ferraz 119 -
-1
votes1
answer1824
viewsA: How to change data from a chart dynamically (DESLOC + RANGE NAME)?
I’d like you to do two things: Post the spreadsheet to feel better what you want; and Tell whether or not you have knowledge in Excel VBA. From what "I understood", it will only be possible with…
excelanswered Thales Ferraz 119 -
6
votes4
answers15143
viewsA: How to create an Excel macro to delete duplicate lines
There are two ways to solve this in Excel. The first is in simple: Using . removeduplicates command from Excel VBA ThisWorkbook.Sheets("sheet1").Range("A1:B8").RemoveDuplicates Columns:=Array(1, 2),…