Search results for query: *

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

I am really tired and just can't figure this out I am trying to do the following If statement, where k is a integer. I want the If statment to proceed if the contents of cell A:k start with a 'P'. If "P*" = activesheet("A:" & k) Then Thanks in advance for the help - Hogie

I have already found the specific files that I need through a bunch of 'If' and 'For' statements meanwhile inside a 'With' statement. - I now want to open up each file and then cross reference ColumnA with columnB in each worksheet in my current excel file. - And then list all rows from the...

SUCCESS... THANKS A BUNCH I didn't know of any other way to make the button, but that did the trick... and so much easier. I also figured out how to see the whole module on one screen. For anyone curious - there is a little button on the bottom left of the module page; "Full Module View". -...

Bong - I think you were on the right track. I need to add the 'PopulateSummary' procedure in the code for the specific sheet ("Summary"). Do you have any idea how I could do this from my main code module? Thanks again

Thanks for the quick reply, I'm fairly new to programing in excel, so I'm not sure if this is answering your question. The "populateSummary" procedure is written in the same module as all my other coding. As a second question on that note... I used to be able to see all my different...