Recent content by Goska

I am attempting to add a button to a word document that will attach itself to an email and go out to 4 recipients. The problem I am having is that Outlook cannont find the names in my contact list, because they are not in there. I am trying to do this with email formats of...

I recently filled out a form in Word, and I was wondering how this was done. There was a small gray box in the space for the answer, and as you typed in it, the box expanded, and would even shift down several lines. Others were size limited so that it would not shift other objects on the same...

Sure, but I don't have your email. Mine is Goska9@hotmail.com.

Can you use the same Headers/footers in all of these? That would make life easier. HTML is such a mess at the top.

Here it is. The bolding is not perfect, I do not get any errors, but there are occasions for duplicate entries, and I can clear the contents of the row, but not delete the row. I have some big changes going on through work starting Monday, so this is probably going to be one of my last posts...

Found the problem. I was truncating 14 into 4. I have the solution, working on some other fixes right now.

NextAddress is the address of a cell "c", ie "A9" right(NextAddress,1) returns the rightmost character in the string NextAddress. You could use 2 to return the 2 right values, and tehre is also a left() available if you ever need it. But the Right() should get the row...

There is a thread in the MS office forum that has a lengthy discussion about the find feature. Try that, and if it doesn't help, post again. Auto Find (CTRL-F) in batch, and store results, macro. Started by Nat101

What I usually do for this kind of thins is write a VBA sub() and attach it to a Ctrl-Letter. I have not had any luck combining it with a shift, not that I have tried really hard at that. Here is some code that should work for you. Read my notes and try it. Sub test() Dim i As Integer Dim...

Worry about bolding later. Set c = .Find(FindMeHere, LookIn:=xlValues,LookAt:=xlPart,MatchCase:=False) Swap this line for the old one. It should be able ot find stuff in the middle of a string/number, and it ignores the case of the letters. RowReff = Right(NextAddress, 1) + 10 might need the...

Since it seems like these quantities are going to be the same all the time(unless your case size gets changed for an item), why don't you use another Vlookup function? Somthing like ="Cases of " & VLOOKUP(A21,BathSecretItems!A3:G27,4,FALSE)& " Each"

1)Try this. Replace your + with a &. + is usually for math, and so it hte #value error. & is for text strings =VLOOKUP(A21,BathSecretItems!A3:G27,2,FALSE) & VLOOKUP(A21,BathSecretItems!A3:G27,3,FALSE) if you need a space in the middle, use this: =VLOOKUP(A21,BathSecretItems!A3:G27,2,FALSE)...

No problem. I do those all the time too and I hate when it takes me 3 days to find it.

I think your comma may be out of place, and you need another & Range("A3:O" & iRows & ",A86:O101").Select So it comes out as Range(A3:Oi,A86:0101).select This works for me.

Use =sum(E10,G10,I10,K10,M10,O10,Q10,S10,U10,W10,Y10,AA10) and it will ignore anything that is not a number, including blanks and text.