Recent content by SBuzzT

lmao! OK, this is working - Finally. Thanks a lot skip. [buying virtual beer] Just a note: I had actually tried that too and gotten an error as well. Just now I realized I had not also updated the other instance of UsedRange. oye k = k & Intersect(c.EntireColumn, [highlight...

I actually thought of that one. Still same error (just tried again to make sure I wasn't crazy).

I'm still playing with this. Now, I get a Compile error: Argument not optional on For Each c In Intersect(rng.EntireRow, , UsedRange) Sub ExCheck() Dim rng As Range, Cel, ms As Worksheet, ws As Worksheet, k, c As Range Set ms = Sheets("Search") Application.ScreenUpdating = 0 With ms...

At least I have a new error now... lol Gives me run time error '438' Object doesn't support this property or method. :(

Still haven't got this (I know; I suck). Any clues on how to make this work?

So, I tried a bunch of ways of doing this (I thought this was close) but I'm getting run-time error '424' Object required in my loop (For Each c In Intersect...) I think I suck at this. lmao If ws.Name = "Sheet1Name" Then With ws.Range("C:C") 'id...

lol Thanks for the encouragement. I was a webmaster (PHP, HTML, Javascript, etc.) awhile ago. VBA is newer for me, but I'm learning...

Working on it... As I have mentioned in previous posts; I'm not VBA expert - I basically just re-purpose what I have done previously. lol

Sorry for not answering, Skip. If I understand what you're suggesting, that would mean people would be looking at the sheet with all the data. That sheet will actually be hidden and locked, so I need the results to appear on the search sheet.

When I execute my code and the search finds the search value: it returns the value from column C (the search value) into D3 (of the Search worksheet) it returns the value from column D of the same row into C3 (of the Search worksheet) I can easily return the Y's that may appear in any of the...

Sorry... Didn't see your more recent post. I'll have to try and incorporate that somehow

Hi Skip. Here's the code. It's similar code that I've used in the past (and I am re-purposing) so I will likely have to modify it further, but it's a starting point for me. Sub ExCheck() Dim rng As Range, Cel, ms As Worksheet, ws As Worksheet, k, NR& Set ms = Sheets("Search")...

Hi excel gods :) I am searching for an value in column C of a worksheet. If the exact value is found (it will be a unique value on each row), I need to check the whole row and return the column header name for each cell which has the value "Y". For example, if I searched for and located 123...

I'll give that a shot. Thanks again, Skip.

You're right: It does look anywhere on the sheet, but the value will be in column O. Originally, there were some sheets it appeared elsewhere, but as I need to be more and more specific, I got everyone to agree to keep the numbers in column O (at least I won that battle). Not sure why, but the...