Search:

Type: Posts; User: Richie(UK); Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.12 seconds.

  1. Thread: Nate Oliver

    by Richie(UK)
    Replies
    57
    Views
    13,228

    Re: Nate Oliver

    The void that Nate will leave in the online Excel world will be huge. I never had the honour of meeting Nate in real life but I'm pretty sure that the real life void will be just as big. My...
  2. Hi A, The following is one approach to looping...

    Hi A,

    The following is one approach to looping through the workbooks in a directory (you could make use of the Dir command instead - see the Help files for further info on this).

    Sub...
  3. Replies
    6
    Views
    897

    Hi Paul, Well, both my post above and the...

    Hi Paul,

    Well, both my post above and the content of the provided link stress the importance of a key element - the Resume instruction. Where is this instruction in the code that you are using? ...
  4. Replies
    6
    Views
    897

    Hi Paul, One of the key points to remember...

    Hi Paul,

    One of the key points to remember with custom error-handling is that you must reset the error-handling (using some form of the Resume instruction) once an error has arisen.

    You may...
  5. Replies
    8
    Views
    849

    ?The paragraph immediately above the code that...

    ?The paragraph immediately above the code that you refer to explains where to place the code! ;)
  6. Replies
    3
    Views
    568

    Hi N, OK, as regards generally speeding-up...

    Hi N,

    OK, as regards generally speeding-up code its worth remembering that the 2 main culprits for making code slow are often calculation and screenupdating. Therefore, you could try switching...
  7. Replies
    9
    Views
    820

    Dude, Have a look at the Offset function. ...

    Dude,

    Have a look at the Offset function.

    For example, ActiveCell.Offset(0,4)
    will refer to the cell that is offset from the ActiveCell by 0 rows and 4 columns, which appears to be what you...
  8. Replies
    3
    Views
    612

    Hi D, Record a macro and in the 'Store macro...

    Hi D,

    Record a macro and in the 'Store macro in' box select 'Personal Macro Workbook'.

    HTH
  9. Replies
    1
    Views
    497

    Hi, The VBAProject protection is relatively...

    Hi,

    The VBAProject protection is relatively weak. However, for the vast majority of people it serves its purpose. I don't think we are going to be thanked by those that try to protect their work...
  10. Hi D, Welcome to the board. Usually they...

    Hi D,

    Welcome to the board.

    Usually they will work without modification. Do you have one that is causing problems? If so, post the code and details of the problems that you are experiencing.
  11. Replies
    2
    Views
    552

    Hi Eddie, OK, you want to clear the result of...

    Hi Eddie,

    OK, you want to clear the result of the formula but not delete the formula itself, right?

    Seems to me that the only way to do this is to clear the values in the cells that are used by...
  12. Replies
    5
    Views
    502

    Hi A, How about? Sub test() Dim i As...

    Hi A,

    How about?
    Sub test()
    Dim i As Integer
    Dim xlFileName As String
    i = 0

    ChDrive "C" ' set default drive
    ChDir "C:\test"
  13. Replies
    15
    Views
    799

    Hi, One tip - when working with Row variables...

    Hi,

    One tip - when working with Row variables you should use a Long data type rather than an Integer data type because the latter may not always be sufficient. See if changing j to a Long helps.
  14. Ditto :wink:

    Ditto :wink:
  15. Hi Phil, Like this: Sub Test() MsgBox...

    Hi Phil,

    Like this:
    Sub Test()
    MsgBox ColLetter(Range("AA2").Column)
    End Sub

    Function ColLetter(iCol As Integer) As String
    'get column letter from the column number
  16. Replies
    4
    Views
    501

    Hi [Select a UserName] The simplest approach...

    Hi [Select a UserName]

    The simplest approach is to enclose your deletion line between:


    On Error Resume Next

    and

    On Error GoTo 0
  17. Replies
    3
    Views
    440

    Hi Kevin, Assuming the original data is in A1...

    Hi Kevin,

    Assuming the original data is in A1 then add this to B1:

    =MID(A1,FIND("-",A1)+1,999)

    HTH
  18. Replies
    2
    Views
    329

    Hi Eddie, If you want to execute Sub2 from...

    Hi Eddie,

    If you want to execute Sub2 from within Sub1 then use the Call statement, like this:
    Sub Sub1()
    MsgBox "Part1"
    Call Sub2
    MsgBox "Part3"
    End Sub

    Sub Sub2()
  19. Replies
    7
    Views
    583

    Hi k, Have you entered the array formula with...

    Hi k,

    Have you entered the array formula with the required CSE keystrokes?

    CSE = Control+Shift+Enter

    Chip's formula works OK when entered in that way.
  20. Replies
    5
    Views
    465

    Hi jem, Yes, change "Sheet1" to the name of...

    Hi jem,

    Yes, change "Sheet1" to the name of the sheet containing the data to be filtered (sorry, forgot to warn you about that assumption).
  21. Replies
    5
    Views
    465

    Hi jem, Try something like this (untested):...

    Hi jem,

    Try something like this (untested):
    Sub CooperativeAgreements()
    Dim wsSrc As Worksheet, wsTgt As Worksheet
    Dim rngToCopy As Range

    With ThisWorkbook
    Set wsSrc...
  22. Hi Jerry, How about: Private Sub...

    Hi Jerry,

    How about:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("C6:C15")) Is Nothing Then
    Target.Offset(0, 1).ClearContents
    End If
    End...
  23. Replies
    8
    Views
    419

    Hi Martin, The Find method can sometimes be a...

    Hi Martin,

    The Find method can sometimes be a little tricky to use with dates. Try using DateValue with your variable, like this :

    Set c = .Find(DateValue(dDate))

    Does that help?
  24. Replies
    4
    Views
    411

    Hi Chris, Chip Pearson has some useful...

    Hi Chris,

    Chip Pearson has some useful routines for working with colour. Have a look here.

    HTH
  25. Thread: tick mark

    by Richie(UK)
    Replies
    5
    Views
    413

    Similarly, you could apply the Webdings font and...

    Similarly, you could apply the Webdings font and enter "a".
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4