Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Page Numbers in MS Word
What you need to do is to insert a "section break" at the end of page 7. The method of doing this differs depending on the version of Word - in XP it is "insert" on the menu, then "break", then click on "next page" under "section break types"...- DSMan
- Post #4
- Forum: Microsoft: Office
-
Excel row to column Transpose question
Zathras' general approach should work, but you'll need to modify it to take account of situations where you have more than two occurences of the same person. (Your example had three for the second person, but there may be more down in the middle somewhere). Also, it sounded as if you wanted the...- DSMan
- Post #7
- Forum: Microsoft: Office
-
How to use EXCEL SOLVER in ACCESS VBA code?
There are lots of options that can be set in solver in VBA, which are set using a number of commands. Either play around with "record macro" to see what VBA writes, or look in the help system (make sure you are looking in "Microsoft Excel Visual Basic Help", rather than the...- DSMan
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Doing math on cells in Pivot Table?
What I understand your macro is trying to do is: Start at A4 If A4 isn't empty then go into the loop Step down one row (to A5) Overwrite the contents of B5 with the formula " =if(B5>0,1,B5)" Overwrite the contents of c5 with the formula " =if(c5>0,1,c5)" (Continue...- DSMan
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
