I am trying to make a function where, based on an article code, the funciton looks in a different sheet with matching codes and takes the right discount (5 columns to the right of the cell with the code).
Then I would like to return a specific value when the discount is set as "standaard"...
I have created a VBA loop that uses multiple .Find combinations to output a single file using a series of ranges defined with a "X" within an excel sheet. The VBA script allows the user to designate any number of fields to be included in the file. When the user selects an odd number of...
I have a macro that runs through a column looking for text - it successfully finds the first instance of the text, however, when I use the .FindNext, the range comes up empty, even though there are 7 more instances of the text. I've tried playing with the search parameters...
I've ran into a Type Mismatch Error when trying to 'set the last row' of a sheet. What I've done was create a separate public function that the original code should use. However, when it goes to the public function, the error arises. What I was hoping was the public function would...
This works fine, but I rather not use .Select
For Each c In Range("F25:F33").Cells
If Not IsEmpty(c.Value) Then
Set FoundCell = Selection.Find(What:=c.Value, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)
I am trying to write VBA to do a specific task, and I am almost there. I simply need a little bit of help to figure out how to do the remaining actions.
Here is what I am trying to do with this code:
1) For rows 11 to 185, search range L11:DK185 for the cell value "X"
2) If "X" is...
Hello my fellow excel-ers,
I am trying to find search through a range of cells in column A from my excel spreadsheet. I know that I can use .Find to find the first match in that range or use .FindNext to find all of them. But my issue is I would like to find the match for my latest...
Good Morning All,
I am new to the world of userform's and think they are pretty dam amazing. I am currently struggling with a small piece of code and was wondering if somebody could guide me.
I have a userform where users need to input results for an employee. The user inputs the employee ID...
I have a script that searches phone numbers
Set rngFind = .Find(What:=Trim(txtLookup.Text), LookIn:=xlValues, LookAt:=xlPart)
Some of the numbers have spaces and some are just numbers.
eg in the database a phone number may show up as "0218888888" or "021 888 888"
Is there a way so when my...
I am running a macro against 20 workbooks. It appears that there is no consistency in how thay are created.
I am trying to copy a few cells from one of the sheets. I am using the .find method to locate the beginning of the data to copy.
I thought I was going to be able to do...
I am working on a macro that will take data from one workbook and move it into another scheduling workbook. When i transfer the data over to the scheduling workbook I need to check to make sure the data i am transferring is unique based upon two criteria, Job# and heat#. If the new data...
I've put together a code for below steps. However, I feel the procedure is too basic and there might be more efficient ways of doing the same. The present code is taking quite long, particularly the .find loop. I would really appreciate any help you can provide.
I'm very new to VBA and try to resolve most of my problems through looking at everyone's helpful posts! however, this time I can't seem to figure it out. I am trying to find "TS" in a specific column and filter for those rows if available. If not available, I just want to exit the sub...
Hi everyone! I'm struggling with the following code which you can see below. It is totally a pain in the *** now. I really need some help.
This code is a search tool which looks for criteria from every worksheet except the summary and the list. After the .Find founds the word, then the code...
Hi all, I'm hoping someone can point out what I'm missing. My macro was working fine until I tweaked it, by adding code to create 2 pivot tables. Now, when it returns to the previous code that finds and highlights a specific Subtotal row, it can't find it. If I remove the new code, the macro...
Hi I've always referred to these forums but I was unable to find the direct answer to my question this time so I figured it was time to create an account.
The basic idea of what I want to do is to use tag based logic to find the category that meets my specified criteria. At First I was just...
Why do these return the same sum value? I thought .find was for total cell value and Cell Like "*5*" finds any cell with a 5 in it.
Set Psize = .Range(Header.Find("0.5" & ChrW(956)).Offset(rowi, 0), Cells(Header.Find("0.5" & ChrW(956)).Offset(rowi, 0).Row, LastColumn))
I am currently working on tool for my team that would enable them to add events to their projects, based on date.
Currently I have a following s/s:
I am trying to get the values from merged cells (which are at the offset of a .find gcell result) through a loop that goes through rows one by one (and looks for specific values on an other sheet) .This code goes if the cell we are looking for is merged and does the following...