search range for value

Hello This my first post so I hope this is clear. I was looking for help to develop a macro that searches a large number of different ranges for values 26 and higher and to write the cell location results to cells B3, B4, B5 or B6. Some ranges may or may not have sets of numbers in...

Hi I have a macro, below, that works just fine but I was wondering if it’s possible to add one condition to it. If someone could just look to see if this is possible I would be very grateful. - The macro searches for any number that is entered in cell B3. - It searches the ranges C3:C20...

Hello- The .Find function does not work if the range (myRange) contains formulae. But it works, when I copy/paste values in the range. Please suggest how I can make it work without copy/paste set findText= .Range("myRange").Find(What:=myText, lookat:=xlWhole, MatchCase:=False...

Hi, I'm very new to VBA and have tried to solve this (have read many threads here) in the last couple of days but have not been able. I hope you fine folks are willing to point out where I'm going wrong. Context: I've got a spreadsheet with items in rows 5-713 down column B(merged up to cell...

Hi all, please bare with me as my first time posting, I am a novice at excel and VB but know the basics, any help is much appreciated. What I am after is a macro, which once played, will check if the values entered in cell (A1) on the active worksheet (Sheet1), are contained in column...