Questions tagged as 'vba'

Tagged questions
1
answer

Split a string

I am trying to make a simple code using split , but there are some errors that I am not able to solve .. in% with% with asterisk VBA informs me that if is out of range .. Sub Getinstrument() Dim instrument As String Dim splitinstr...
asked by 10.09.2014 / 18:02
1
answer

Excel 2007 - Buttons to create / remove rows

I have a table in excel with one line only (plus the header) and six columns. The entire sheet is protected except this line. At the end of the table I wanted to have a (+) button that adds a new row, and a (-) button that removes the last ro...
asked by 05.06.2014 / 15:59
2
answers

Copying rows from one table that match one criteria and pasting into another Excel sheet

Hello! I am something new in VBA and I have gotten what I want through the macro recorder. However, I think that in this case I will not get what I want through this feature. I'll try to be clear on my goal. My Excel sheet is called "A3"...
asked by 28.02.2018 / 14:54
1
answer

Separate equal, odd, and equal numbers in matrix by VBA (Excel)

How to make a 10x10 matrix, separate odd and even and odd without Mod?     
asked by 04.07.2016 / 01:07
1
answer

Select an option that is only possible by mouse click with vba

I'm trying to develop a script with vba, in excel , to facilitate a routine we have at work, which inserts about 9,000 data into the internal system. We are currently manually inserting this data. This data will never be the same since it is...
asked by 13.06.2016 / 04:20
2
answers

Excel move non-duplicate values between two columns to a third

I have a question and I can not get a plausible answer. I have a worksheet in which I would like to make a comparison between two columns and say to it that if there is a value that is not duplicated, that same value is moved to a new column. Fo...
asked by 04.03.2016 / 02:23
1
answer

Hide results in Excel

Good afternoon, guys. I have the following problem: I have several lines and each of them is protected with a different password for the edit, each one corresponding to a company unit. I need the values to be hidden for those who do not know...
asked by 24.06.2015 / 19:49
1
answer

Is it possible to rename a folder with files inside using VBA (Outlook)?

I have a simple process where a text file arrives by email and I should save it to a certain location inside a folder whose name is a date that is inside this file. With this in mind I have developed the code below that does the following proces...
asked by 06.01.2015 / 15:48
1
answer

Excel can not read cell in VB code

x.Range("A1:z1").Select x.Goto Reference:="R2C4" verificaCel = x.ActiveCell.FormulaR1C1 if verificacel then I am not able to read the specific cell in the excel sheet, in which I will send the data to a database.     
asked by 04.10.2017 / 14:24
1
answer

How to make a "for each" loop in column P up to the last line filled in VBA?

If you set the entire column P:P the sheet will freeze. How do I set rng , any ideas? CODE: Sub teste() Dim rng As Range Set rng = Range("P2:P300") 'Estou a definir até à linha 300 para não quebrar For Each Row In rng.Rows If...
asked by 03.06.2017 / 19:30