Search:

Type: Posts; User: CephasOz; Keyword(s):

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    1,213

    Sorry ... I don't have Outlook on my system, so I...

    Sorry ... I don't have Outlook on my system, so I can't answer that. It would seem likely, but I don't know and can't check. (We're a Notes shop, sadly.)

    With the full spectrum of possibilities...
  2. Replies
    4
    Views
    1,213

    Your toolbars will still work in Office 2010 -...

    Your toolbars will still work in Office 2010 - you'll find them on the Add-Ins tab that appears when you have custom menus or toolbars.

    If you want to get into programming the Office 2010 ribbon,...
  3. You could try using the following code to select...

    You could try using the following code to select the range:

    ' Select the range to be used.
    Sub SelectRange()
    Const cdblTopDataRow As Double = 2
    Dim dblLastCol As Double
    Dim...
  4. Replies
    1
    Views
    610

    Right-click the "Sheet1" tab, and select "View...

    Right-click the "Sheet1" tab, and select "View Code".

    In the VBA code screen, paste the following code (if you change the column for discharge date, change the number shown):

    Option Explicit
    '...
  5. Replies
    2
    Views
    654

    Try changing the formula in C2 to be...

    Try changing the formula in C2 to be =OFFSET(Sheet2!$F$3,MATCH(A2,Sheet2!$F$3:$F$6),MATCH(B2,Sheet2!$G$2:$L$2))

    Then copy it down.
  6. Surely this is just another way of telling the...

    Surely this is just another way of telling the world what your date of birth is. Colour me paranoid, but I think it's not really a good idea.
  7. You can use the function VLOOKUP to get details...

    You can use the function VLOOKUP to get details from your master list. Without an example spreadsheet, or a bit more information about exactly how you want to combine data, it's difficult to be more...
  8. Would a pdf file serve your purposes? In Word...

    Would a pdf file serve your purposes? In Word 2007, "Save as", "PDF or XPS" allows you to save your document as a pdf file. It uses the hyperlinks in the output pdf document, and it's a quick and...
  9. Replies
    9
    Views
    2,739

    rory, thanks for your concise code. I've used...

    rory, thanks for your concise code. I've used Excel since it first came out, including R1C1 notation, and I've never seen an absolute reference in R1C1 before today. They've all been relative...
  10. If you want a tool that will reduce the pain in...

    If you want a tool that will reduce the pain in dealing with the Ribbon when you're doing the 2007 version, go to http://leafcreations.org/ and download the Ribbon Editor.
  11. As you've outlined it, there's insufficient...

    As you've outlined it, there's insufficient information to sort out the problem, because there's no data in C5:C13, it's unclear what you want to do with A21:A34 (in which there's also no data), and...
  12. Replies
    9
    Views
    2,739

    If you still need the VBA, I think this will do...

    If you still need the VBA, I think this will do the trick.



    ' Create SUMIFS formulas for Non-SARS credits & debits.
    Sub CreateSumifs()
    Const clngSumCol As Long = 7 ' Column G
    ...
  13. Replies
    9
    Views
    2,739

    Sum values depending on 2 conditions

    I think the following formulas will do what you want.

    =SUMIFS(G2:G12,G2:G12,">0",F2:F12,"<>SARS")
    =SUMIFS(G2:G12,G2:G12,"<0",F2:F12,"<>SARS")

    Just replace the 2s and 12s with the appropriate...
  14. Copying without changing the format of the destination range

    I think this should do the job.



    Sub CopyToMaster()
    Dim wksMaster As Worksheet
    Dim wksSlave As Worksheet
    Dim rngCopy As Range
    Dim lngCol As Long
    Set wksMaster =...
  15. Copy selected column from used range

    Is this the sort of thing you're looking for?



    Sub CopyToMaster()
    Dim wksMaster As Worksheet
    Dim wksSlave As Worksheet
    Dim rngCopy As Range
    Dim lngCol As Long
    Set...
  16. Replies
    3
    Views
    947

    What about ... Do While...

    What about ...

    Do While ActiveDocument.Shapes.Count > 0
    ActiveDocument.Shapes(1).Delete
    Loop
    Do While ActiveDocument.InlineShapes.Count > 0
    ActiveDocument.InlineShapes(1).Delete
    Loop
  17. Windows Media Center not showing all TV channels

    I'm running Windows Media Center on Vista Ultimate SP2. Prior to upgrading to SP2, I could watch TV on WMC through my tuner card (DVICO DVB-T Dual Express), but now WMC doesn't show some channels at...
Results 1 to 17 of 17