Tag Archives: search

Searching over multiple columns in excel vba

Questions: I am able to search a text in column A of my spreadsheet by using this With WB.Sheets(“MySheet”) Set FindRow = .Range(“A:A”).Find(What:=”ProjTemp1″, LookIn:=xlValues) End With After which I can get the row number by doing FindRow.Row How do I then get back the row number where Column A == “ProjTemp1” && Column B ==… Read More »

How to search on worksheet by VBA Code?

Questions: I have a worksheet with 2 columns “Key” and “Value”. by VBA code, i want search Input_key on Key columns, if not exist, I will add new row [input-key]-[input-value]. How do i code? Answers: You will realise from the comments that “please solve my problem for me” questions are not popular. I will guess… Read More »

Excel VBA that searches by header name not column

Questions: I need a VBA macro that does the below: This part works fine, I want it to make a new column on sheet1 and name it header name then color it. Columns(“P:P”).Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range(“P1”).Select ActiveCell.FormulaR1C1 = “Header Name” Range(“P1”).Select With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 15773696 .TintAndShade =… Read More »

Searching a log file [duplicate]

Questions: Possible Duplicate: Searching using Regex in VIM or elsewhere I’m searching a huge ~600 Mb file for a particular pattern which is 7 Hexadecimal values long. The Problem is the ‘pattern’ could be on the next line and there are several addressing lines. I got rid of problem 1 by getting rid of all… Read More »