Posts by Andréa Aline • 130 points
32 posts
-
0
votes1
answer71
viewsA: Excel - ZIP code range
How are you? First, it should be noted that the way you tried to perform this search would not work this way with PROCV, because this formula searches for keys (value sought) exactly equal to the…
excelanswered Andréa Aline 130 -
0
votes1
answer28
viewsA: data types inside the vba
I believe there are two ways to solve your problem. In the column where data needs to be converted from number to text, you can apply the function CStr, that converts values into a cell for text…
-
0
votes1
answer26
viewsA: Copy table data sequentially with VBA
All right? I don’t know what the entire structure of your spreadsheet is, so I focused on the problem you pointed out, namely consolidating information distributed across multiple columns in a…
-
0
votes2
answers34
viewsA: Active X buttons
Hello! I believe it wasn’t exactly what you wanted, but the most I could do was this:: When passing the mouse, change the color as you did. Then, by clicking back on any cell of the sheet, using the…
-
0
votes1
answer26
viewsA: VBA - Copy and paste column to the new tab with the given code
Here’s my suggestion on how to do that. Already I say that is not the most practical way, but as your question involves only two columns, it is possible to do so. However, I did it in a way that…
-
0
votes3
answers42
viewsA: Average function in excel
All right? I believe the code below can help. I did based on the spreadsheet that you showed above. Basically, it sums the values of column A:A according to the interval stipulated in cell "E3".…
-
0
votes1
answer102
viewsA: VBA to save in PDF the Excel spreadsheet with the name of two Cells
From what I understand, you want the values in cells S7 and D13 to be present in the PDF name to be created. To do this, just concatenate, using "&", the statement "Range('Cell address'). value"…
-
0
votes1
answer27
viewsA: Concatenate two columns with Excel Vba in six different tabs
How are you? As you need to fill in a few tabs, the solution can be solved with a "For...each" repeat structure and an "If" clause". Basically, the code below goes through each tab of the worksheet…
excel-vbaanswered Andréa Aline 130 -
1
votes2
answers61
viewsA: Is there any way similar to the python . format method for VBA in Excel?
All right with you? I believe that what you are looking for would be something like the code below, that is, assign a value to a text variable and create a link using the value of this variable: Sub…
-
0
votes1
answer45
viewsA: how to print table in two columns?
Hi! I did a slight gambit, but I believe it brings the desired result. As it is not possible to adjust the print configuration to print two columns, my idea was to create an auxiliary tab in which…
-
0
votes1
answer18
viewsA: Problem in VBA Debugger
Hello! I tested the code sent, first, with the spreadsheet tabs with some filled cells. In this situation, the debugger traversed all lines. Then I tested the same code without filling the cells and…
-
0
votes1
answer42
viewsA: Repeat image for lines below - MACRO
First, thank you for returning my comment by posting your code! Basically, what I did was change the variable to capture the image from "Shape" to "Picture" and thus use the Insert method, which…
-
0
votes1
answer26
viewsA: How to transform multiple columns into 2 columns with vba?
Good afternoon Thaís, All right with you? My suggested code has become giant, but I believe it will solve your problem. First, note that the structure of the tabs I used to test are as follows:: Tab…
-
1
votes1
answer40
viewsA: VBA Script Help for excel
Hello! How are you? I tested your code (obviously adapting to save the files in my folders) and the result was that the code created a folder with the value of the A9 cell in the same folder where…
-
0
votes2
answers87
viewsA: Delete rows that in the column contain a certain value
Poxa... please, you created the auxiliary spreadsheets that I mentioned in the explanation? Also, the code I passed you incorporated into the original code or inserted into a separate module? The…
-
0
votes1
answer31
viewsA: Refreshall crashes VBA execution
Smooth? I don’t know how many dynamic tables your spreadsheet has, but one possibility is to name in the code the list of dynamic tables to be updated. For example: ActiveSheet.PivotTables("Tabela…
-
1
votes2
answers87
viewsA: Delete rows that in the column contain a certain value
Follow here my code suggestion to help. I tested with a spreadsheet with 70 thousand lines and ran in 3 minutes. It should be noted that I made this code on the assumption that it is necessary to…
-
0
votes2
answers40
viewsA: Compare the value of a cell with the name of a tab in VBA
To help you with this situation, I would like to please raise the following points: How is the name of the employees in the "List" tab updated? Someone copies and pastes the names every month or so?…
-
0
votes1
answer215
viewsA: vba excel to save sheets of a pdf file with the name of each sheet
All right? This is very simple to do! For the PDF file name to have the same name as the spreadsheet tab without you having to enter the name every time, just replace the code: strNome =…
-
0
votes3
answers60
viewsA: Vba - Graphic + Show Detail
Hello! I believe that now goes! Instead of selecting the chart to show the details, try saving the macro by directly selecting the dynamic table, in case, in some row of the Value fields. I tried it…
-
0
votes1
answer30
viewsA: I have a code in vba that when running shows error 438
Hello! All right? I believe you’ll laugh when you read this, but it wasn’t working because you missed an "s" in "getElementByTagName" and "getElementByTagName". The correct is:…
-
0
votes3
answers60
viewsA: Vba - Graphic + Show Detail
Looking at the documentation and its response, what may have occurred is that the "Enable Detail View" option is disabled. To check this and possibly enable this option again, do the following:…
-
0
votes2
answers234
viewsA: Calling module inside another module in VBA Excel
Hello! When I separated into different modules, this problem did not occur. In this case, what I did was right-click on Planilha1(OS)>Insert>Module (image below) and, in this module created, I…
-
1
votes3
answers60
viewsA: Vba - Graphic + Show Detail
Hello, The "Show Detail (Show Detail) property is unique to dynamic tables. If the graph in question is not a Dynamic Graph (that is, created from a Dynamic Table, through the Dynamic Graph option),…
-
0
votes1
answer55
viewsA: Return all correspondence in excel
Hello! A change in the formula that can help is to check if the cell contains the searched text, as follows: =SE(ÉNÚM(LOCALIZAR("Texto Procurado";A3));"OK";"Não OK") Whereas A3 would be the…
excelanswered Andréa Aline 130 -
0
votes2
answers540
viewsA: VBA programming error: runtime error '-2147417848 (80010108)'
Hello! This is a very common problem and is related to the level of integrity at which Internet Explorer (IE) is configured. An alternative that usually works, using the above code is to replace the…
vbaanswered Andréa Aline 130 -
0
votes1
answer112
viewsA: Add items to listbox
First of all, your question is not stupid. Secondly, your code was mislabeled in ". List(1, 0) = "Distribution", because the line and column positioning in . List is inverted (right is (0.1)).…
-
0
votes1
answer135
viewsA: How to open a VBA website
Good morning, I tested the code above and what happened was that, after the execution of the first part (which accesses and authenticates on the Tray website), opened a new tab in Internet Explorer…
-
0
votes1
answer31
viewsA: vba data conversion
Hello! Yes, it is possible to insert a clause if to solve this case. First, reading this part of the code you posted, I got the impression that you created a code block for each file name to be…
-
0
votes1
answer35
viewsA: Error in excel vba, using . offset, to search for products in a spreadsheet
Hello, Please, could you provide more details of the reason for using the VBA in this case? I ask, because as it comes to the search for a product for a unique code, the use of =PROCV(VLOOKUP) in…
-
0
votes1
answer668
viewsA: Condition in VBA if Date reported in Textbox is Higher or Lower
Even if your Excel is configured in English, there is no need to change the date formatting on your spreadsheet. I’ve done comparison dates with "Brazilian" standard in Excel configured in American…
-
1
votes1
answer59
viewsA: I’m starting in VBA, can you help me?
Good morning Lucas, The code below should solve your problem. Basically, I created two variables to manipulate the two tabs and a variable that stores which was the last line with values filled in…