seach

Hello, I'm trying to make a search function, what looks for the entered value in an array, and links a TextBox to the search results neighbour cell. I have the formulas needed to get the row, column or address of the cell that should be linked, but I can't select a linked cell as a...

Hi, I have some text in column A similar following table and I want to extract timings after 04:00 PM, <tbody> Timings Output <colgroup><col width="319"></colgroup><tbody> 03:15 PM, 06:15 PM, 09:15 PM </tbody> <colgroup><col width="190"></colgroup><tbody> 06:15 PM, 09:15...

Hi Everyone, As you can tell by my username, I am very new to Excel VBA. I just started really utilizing it when I first realized that I can record a macro; however, as I continued it, realized what a powerful tool it can be for my work place when utilizing various data sheets. So far, many of...

I have a database with 2 columns like: (example) <code>AA 6 VE 9 HE 18 AO 12 PF 7 The code to search the rows I want, and to clean the search is already done: <code>Sub B2_Click() Dim c As String Dim l As Integer c = "B" l = 2 Do While Not IsEmpty(Range(c & l)) If Range(c & l) >...

Hey mr.Excel I'm trying to make a marco that seach the active sheet for the value of the sheet FAM cell A1. Is this possibel to do??. Dim i, lastrow For i = 1 To lastrow If ActiveSheet.Cells(i, "G").Value = Worksheets("FAM").Cells(A1).Value Then ActiveSheet.Cells(i, "G").EntireRow.Copy...