cells.find

So I am searching for a certain word, which is "Violation" and then filling in something from a combobox from a userform into that spot after "Violation." So if I enter "12/1/18" into the combobox in the userform, it will find the word "Violation" on the main page and then plug "12/1/18" right...

Dear Gents, I'm in sheet2, and I want use cells.find method to get the column number of sheet1 that contain specific words like "LogNo" Dim d, e As Long d = Cells.Find(what:="LogNo", After:=Sheet1).Row But it shows errors. Could you please help me to figure this out? Thanks.

I would like to use the name of activesheet to enter in data on other sheet on corresponding name, but without selecting or activating that sheet. I have a working formula below, but is there anyway to avoid selecting the other sheet? Sub mark() Dim findx As String findx =...

What's wrong in this? With Application.FindFormat.Font .Name = "AmplitudeTF" ' .Subscript = False ' .TintAndShade = 0 ' .ThemeFont = xlThemeFontNone End With Cells.Find(What:="", SearchFormat:=True).Activate I am getting an "Object variable or With block variable not set"

A code like below: Cells.find("(" AND ")") I just want to find whether any bracketed values are there... Thank You.

I'm using multiple "ON ERROR" calls in a macro but I keep getting errors after the second iteration. I'm using the Cells.Find function when I get the error. Here's some of the code and the error I get: On Error GoTo NextOperation Do While Cells.Find(What:="cont'd", After:=ActiveCell...

Hi all, I'll outline the details of my set up in dot point form:- I have a sheet called "IAR" It has a table also called "IAR" I have a named range on this sheet called "IARcol" which references the formula "=IAR[[#All],[Job No]]" I have another sheet called "notes" It has a table called...

Hi, I have two sheets in a workbook. The first sheet is named "A" and the second sheet is named "B". Both sheets are identical i.e. they have data ranging from Columns A:AI. However, the number of rows are variable. I need a macro that will run in loop by looking up data that is mentioned in...

Hello to all, I have a worksheet with IF statements that place different messages in cells if the user has not provided enough information, or incorrect information, etc. Here are the messages: Check % Complete Actual Missing Remaining Missing Zero Out Remaining ?? enter date Qty? I am...