Search results for query: *

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.

Here is the working version. Copies the info to the next sheet, gives a cell ref first, then pastes the data. Cell refs are only once per row; multiple occurances in a row are eliminated. I hate cosmetics, but here you go. If you leave copy statement 1 in, then it will bold both the original...

Actually, my code was just a hack and paste from the Excel help files to begin with. Working on the next solution. THought it was just really slow. Turned into an infinte loop. And of course I didn't save it before I ran it.

This sub matches any item in the range D14:AA128 with the value in cell A1, then places the cell name (A1, B6, etc) in column A of sheet2, in the order that it finds them. Note that there is no delete in here, so old values will not go away unless you code that in too. I think this is what you...

You could do a =month(b2), then a Vlookup of some table that you made. The month function returns 1-12, so make a 2 column table of 1-12 and Jan-Dec, and use this for your output.

Solved my own problem, for this case at least. I've been cussing at the computer for 3 days on this one, and I just gave up and cheated. I made a new sheet named BLANK, and I'm just copying all of the info in my print range over to that one, reformatting it, and printign from there.