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...
Hello, I am developing a code to search in an external workbook a determinated value, the fact is that external workbook has many sheets and we are having trouble making the code to search in each sheet. Here I leave you the part of the code that, without the red part, works when we look in a...
Hi - I created the following code to find the word "result" on a worksheet and if found, delete the row. The code below works but displays an error after it runs:
Object Variable or With block variable not set
The error relates to the code highlighted in blue below:
Dim i As...
I need to:
1. Find a column containing the word 'target' in header. (from the range P1 to QI1 )
2. Delete all other column without 'target' in its header.
Dim rng As Range
Set rng =...