Recent content by jhogie

Yes this does work! If wkb.Worksheets("MESL").Cells(k, 2) Like "CD-0*" Then

Thanks PHV! This one still did not work: If wkb.Worksheets("MESL").Cells(k, 2) Like "CD-0*.*" Then But, this seemed to do the job (should have thought of this myself): If Left(wkb.Worksheets("MESL").Cells(k, 2), 4) = "CD-0" Then Thanks Skip - I had thought of going that direction, but I am...

I have an excel file where in Column B there are various strings that all start with "CD-0". I am trying to enter my 'if statement' if the cell starts with "CD-0". Note: the cells that start with "CD-0" are all several cells in the B column merged together (so it should read it in the top...

Firstly, I must admit that I am embarrased that I need to ask this question. I have a column where each cell has a different text. In the adjacent column I would like to indicate if the column contains a specific string. ie. Does column 'A' contain the string 'ic' A B Rick...

BRILLIANT! I knew there was a simple way of doing it. Thanks for the help.

I have a HUGE list of items in an excel column. Some of the items are repeated. I need to eliminate all the repeated items... so that I have a list where each item only appears once. I've done this in a long, indirrect, inefficient module, however I'm sure there is a simple way to do it. If...

I simply posted a simplified version of my module. In my ACTUAL program it is not 10 (or 9), it IS a variable. It is a legitamate question. Thanks for posting.

I did know that arrays start at zero. But I really like the trick for redimensioning the variable... it did the trick, THANKS

This seems simple, but I can't figure it out, and I couldn't find in another forum. Below is my simplified code. I want to create an array ('Tag') that will contain string variables. The array should be the size of 'TagCount' (ie. 10). I get the error "Constant Expression Required" Sub...

Thanks for the reply and the 'F9' tip. The purpose of AC11+1 is to look up the column to the right of the one corresponding to AC11. I have figured out a solution that works: =IF(X8="Remove From Program","Remove From...

I will try to describe everything the best I can. The following are in my excel: X11: can be "Remove From Program" or any positive integer (in this case it is 22) AC11: 1, 2, 3 or 4 (in this case it is 4) Row of cells starting at AE3: 1 2 3 4 5 Table array starting with...

Thanks Skip for the quick reply, but I don't think I explained my issue well enough so your code doesn't fully address work. However, I actually figured out a different (longer) way of doing it, and it is posted below (for anybody to look at). Here I am determining the length of the Tag# and...

I've been working on this one for a while and quite seem to get it. I have a sheet ('SheetName') full 'i' number of Tag #s in Column 'A'. The Tag #s are either L-##### or LL-##### (where L/LL are specific combinations of Letters) I am wanting to enter the 'If Statement' if the Tag #s appear...

Thanks guys! Once again, Tek-tips comes to the rescue! - Hogie

I am trying to write an If statement to see what row A cells start with a 'P'. I am pretty tired and can't figure this simple one out. (k is an integer) If "P*" = ("A:" & k) Then