| Recent Answers |
 |
|
2008-08-29 Excel - Move Cusror from one sheet to another sheet using for loop: Panneer, Private Sub CommandButton1_click() Dim sh as worksheet, sh1 as worksheet Dim i as Long, r as Range, r2 as Range cnt = worksheets.count set sh1 = worksheets.Add(After:=worksheets(cnt))...
|
2008-08-28 Microsoft Word - toc: I have no experience with style separators, but you shouldn't need to press Enter to use one. Instead, insert the style separator between the text you want included in the TOC and the text you don't want...
|
2008-08-28 Excel - Index/match with submatch: Amber, Match should work, but there are three modes... which one are you using? perhaps you omitted the last parameter (Match Type) in the Match function. According to the Excel help file (regarding...
|
2008-08-28 Microsoft Word - List of tables/figures: If I'm interpreting your question correctly (hard to tell the way it appears here), what you need is a right indent in the TOC style. In the article at http://sbarnhill.mvps.org/WordFAQs/TOCTips.htm, see...
|
2008-08-28 Excel - Insert cell value (date) into a link: No problem, you can make the part of the row dynamic using the ROW formula, for example: =INDIRECT("C:\2008 Weekly Analysis\[WE " & TEXT(A1,"yyyy-mm-dd") & " WKD USA Retail Analysis.xls]USA Formulas'!$D$"...
|