Search results for query: *

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...

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...

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...

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...

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...

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...

I posted a similar/same thread yesterdaym, however it has seemed to have dissapeared. I have created a command button with caption "update" using the following code (wkb = ThisWorkbook). wkb.Worksheets(1).OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False, DisplayAsIcon:=False...

This seems like it should be simple, but I just can't figure it out. I have an excel worksheet titled "Equipment", with several worksheets before and after it. I would like to find out what worksheet number "Equipment" is. Here is A line I've been playing with. EquipNumSheet =...