Recent content by yimitz

I have a field of data that looks something like this: C320-EB-17-SOME NAME I need to extract just the part that is SOME NAME. In Access I'd use INSTREV and search for '-' then do a left function from that point. The data is variable so I can't just count on SOME NAME starting at the same...

Thanks, I didn't have time to work it through, it was a immediate need sitation. Now that I solved the immediate need I will work on updating the routine to clarify the required range and clean up the approach. Thanks again!! Once I have it completed I'll let you know.

I thought the color index for red was 3 instead of 45.

Just wanted to give you my end result code that works. It's not perfect for every possible situation but it does what needed in a heartbeat. Thanks to Skip for all the assistance! Sub MColorMe() Dim myMatchVariable As Variant...

That's the thing, the range will be variable I'm afraid. I think to start I would say it would be no bigger than 13 columns and 500 rows.

4 different values so that's fairly easy. The tough part now is walking two columns over and highlighting the values in this column, etc, etc. and then also doing this same walk through for 10 worksheets. Is there a "for each worksheet" routine that would simplify this?

That's the ticket! I was using Set P1 = (VBCode for lookup) No more errors. Now I just have to set the background color of the cell based on the value the lookup returned. Thanks for the assistance!!

A4 is the exact value. It would be referencing Sheet1!A4 value. my first line of code is setting focus to sheet1 and cell A4.

I don't want to add to the worksheet, just change the highlighting of the cells based on walking through the cells with values and doiing the comparison. I was thinking of calling the procedure in an on-open routine(?) make the changes and save it, I haven't really thought that far ahead...

I want to look up one value in sheet1 that will have a matching value in sheet2, I have to walk through each cell value and highlight matches. Here's my code: Application.VLookup(Range(myRcdA).Value, Range("A3:D535"), 3, False) Range(myRcdA) will have data in sheet1, I need to match that to...

Visual Basic but if there is a better, simpler language I'm confident I can pick it up and get an understanding of it.

Is there an example of a simple script somewhere that I could see and walk through to see how it's done?

Is it possible to create a batch script or some other script to look at a web page with links within the page, open the link (link is to a file for downloading) and have the script automatically put the linked file (zip file, excel, text, etc.) somewhere on your harddrive?

That could be an option because then if I wanted to save the selections I could do a make table type query or SQL update query to save the data. I didn't really think about that angle.

Anyone have an example of doing something like this? I have a form based on a table which relates to another table (subform holds this info) that I want to be able to select a check box and return those selections inthe main and subform to a seperate temporary table. I don't know if I'm being...