Search results

Nararyan... thank you for helping me out with this. I am having trouble getting your formulas to work and I'm sure it's because my description of the issue could have been better described. I have attached two spreadsheets; the "Result" is looking in the "Source". You'll see that A1 in "Result"...

This formula looks in A1 for the text "SPE |" and if found it displays the entire row, if not found it displays nothing... it works perfectly good. I'm trying to figure out how to get it to look in several or all cells of the row and again if it finds the text in any of those cells it’ll display...

In addition you must reference Word Object Library. In the VBA editor click Tools > References and check Microsoft Word xx.x Object Library. Sub DeleteTextBox() Dim Inspector As Outlook.Inspector Dim wdDoc As Word.DocumentDim Shp As Word.Shape Set Inspector = Application.ActiveInspector()Set...

This may be a shot in the dark because it's an Outlook macro issue. Below are two sets of code that deletes text boxes, the first one works in MS Excel and the second in MS Word. The only difference between the two is the third line after "Active". I'm trying to duplicate this action in MS...

Awesome, thank you Khalid

Very nice... thank you so much

I have this formula that looks for "PW" and displays the line in Sheet 1 if it’s present. I'm looking to add maybe an OR statement so it looks for "PW" & "DW" & "SPE"... if a line has any one of these then it's displayed in sheet 1, if there are none then it is not displayed. Any help will be...

WOW, I'm blown away, talk about a cornucopia of information and choices. Villalobos… the InputBox, this is off the charts awesome, what a great feature and idea. It just occurred to me that what you’ve done will allow me to do much more than I had started out to do, including picking my next...

I'm pretty sure it is possible to use RANDBETWEEN without getting duplicate numbers, but I have not been able to figure it out, any help will be greatly appreciated... I've attached a spreadsheet.

Got it, very helpful... thanks guys

SUMPRODUCT did the trick, thank you. Just for my own knowledge, if I was to use VLOOKUP and only look in column B to get the results from column A, why doesn't this work? =VLOOKUP(2,B2:B26,1,FALSE)... I'm looking for a number "2" in column B which should then result in displaying whatever is in...

I thought what I was doing is looking in B2:E26 for the number "1" and in this case C30 would display the text in the first column which would be "Ken".

I'm baffled... in the attached spreadsheet cell C30 is a VLOOKUP formula that I can't figure out why it's not working, can someone please enlighten me, what am I doing wrong?

Chirayu... perfect, you've resolved all my roadblocks, thank you for your awesome input!

I've run into a bit of a problem and didn't foresee this earlier... I need cell AJ2 to return back to its original text. I thought I could just change a plus to a minus in the code but clearly that doesn’t work, sorry but I'm just a grasshopper here.

Ah yes I see now, thanks… I'm a little smarter now

Marc L... I like the simplicity of your code and it works as long as the split line has a number in it, when I replace "9642A-001" with "AJ2" which is where the number resides and will change the macro errors out... thank you.

Chirayu... both your suggestions work great, your second one is the way to go, thank you so much.

I'm using the code shown below and it works great. Basically it looks at cell AJ2 to determine which file to open. In AJ2 is a number something like 9642A-001, I'm looking to add a +1 to this number resulting in it looking for 9642A-002... is this possible? Sub OpenSubItem1() ChDir _...

Villalobos & Shteven... excellent, it's like a Greek restaurant in the USA, so many choices. You make it look easy, thank you so much.

This seems somewhat elementary to me but obviously my skill level is not there yet. In cells A1:A5 are numbers, in B1:B5 I’m looking for a formula to look at column A, locate the largest number in that column and duplicate that number into the corresponding B cell. So, if the largest number is...

Can someone tell me what I should change here to run this only on the selected row rather than the entire worksheet? Dim h As Hyperlink Dim oldDr As String, newDr As String oldDr = "\Public\2014\" newDr = "\Public\2015\" For Each h In Sheets("Shipped").Hyperlinks h.Address = newDr &...

Very nice, works perfectly... thank you

I'm passing this on FYI... a lot of research happened here. I'm not smart enough to know why this works but it does and maybe it'll help someone else down the road. Dim h As Hyperlink Dim oldDr As String, newDr As String oldDr = "\Public\2014\" newDr = "\Public\2015\" For Each h In...

RmDir "H:\Public\" & Cells(Application.ActiveCell.Row, 2).Select Above is my amateurish attempt to make a macro that deletes a directory that has the same name that is in column “B” of the selected row… H:\Public\ never changes but everything to the right which is the same as text in column “B”...