Search:

Type: Posts; User: Von Pookie; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.39 seconds.

  1. Thread: Nate Oliver

    by Von Pookie
    Replies
    57
    Views
    13,244

    Re: Nate Oliver

    W h a t???
  2. Replies
    2
    Views
    273

    Re: Change event

    Try this:


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Intersect(Target, Range("Rego")) Is Nothing Then Exit Sub
    Application.EnableEvents = False...
  3. Re: Adding a website hyperlink to a cell where data is brought back using a formula

    Have you tried nesting the VLOOKUP result into a HYPERLINK formula?
  4. Re: Display formula output to a different cell, continuously

    One option: use a Calculation event on the worksheet. The event macro will run every time the worksheet is recalculated and when the formula updates/recalculates, so will C11.


    Private Sub...
  5. Re: formula only works validating if cell type is general.0

    What is your "VB formula?"
  6. Replies
    3
    Views
    4,311

    Re: Copy format only from cell above

    Just use Paste Special. Give this a go:



    With Selection
    .Offset(-1, 0).Copy
    .PasteSpecial Paste:=xlPasteFormats
    End With
  7. Re: VBA %username% macro to run different code

    You basically use the same sort of setup. In this particular example, I used a Select Case statement instead of nested If/Then:


    Sub asdf()
    Dim Uname As String
    Uname = Application.UserName...
  8. Replies
    7
    Views
    559

    Re: Help with adding a loop to a Macro

    Frank,
    There was something weird going on with the HTML example you posted; I had to remove it. Please feel free to try posting it again.
  9. Replies
    7
    Views
    4,493

    Re: VBA - File Location from cell contents

    It appears that it is trying to use a date as the folder name, not your "Validation..." string you say is the folder name.

    I think this error may be occuring when you are OPENING the workbook,...
  10. Replies
    7
    Views
    4,493

    Re: VBA - File Location from cell contents

    I would think there has to be something, somewhere. Maybe we can make it tell us what the actual error is?

    Try adding an error trap in your code and see if it tells us anything:

    Sub...
  11. Re: copying more than one selection at once

    As long as all of the necessary workbooks are already open, your "office ladies" shouldn't see any screen "tabbing" if you code things correctly.

    As you have your code currently, it won't visibly...
  12. Replies
    7
    Views
    4,493

    Re: VBA - File Location from cell contents

    Hrm. Just to be specific--what line of code is highlighted when the error occurs?
  13. Replies
    7
    Views
    4,493

    Re: VBA - File Location from cell contents

    What is the text in cell B2?
  14. Replies
    3
    Views
    645

    Re: Improving thread "bumping"

    The "unanswered list" isn't really "unanswered," anyway.

    It's just filtering the last day's worth of question by number of replies.
  15. Re: Facebook doesn't like MrExcel.com links

    It is being looked into.
  16. Replies
    5
    Views
    398

    Re: macro-ize these manual key strokes

    I'm not really sure what you want to do with item #2 there--if you just use Ctrl+End you're not just going down one row, you're going to end up wherever the data is. I can't control that.

    As far...
  17. Thread: RSS feeds

    by Von Pookie
    Replies
    1
    Views
    430

    Re: RSS feeds

    No, I do not believe so. I think there used to be one for the main Excel Questions forum but I don't know what happened to that.

    However, you do have the option of "subscribing" to any thread you...
  18. Replies
    2
    Views
    274

    Re: Do Until Loop query

    This seems to work for me--

    Change this:

    Do Until Application.OnTime TimeValue("07:02:00"),

    To this:

    Do Until Format(Now, "hh:mm:ss") >= "07:02:00"
  19. Re: Please help with Error 9 Subscript out of range.

    Have you made the stCoCPath a public variable? Just because you set the variable in one macro does not mean that it is set in all of them.
  20. Replies
    12
    Views
    843

    Re: help for formula

    Hello Kamlesh--

    Do you have a list of the employees in the spreadsheet?
    If yes--what cells?

    If no--you will need to make a list of the employees in the spreadsheet and tell us what cells.
  21. Replies
    2
    Views
    480

    Re: Tweek this VB?

    It's possible I've missed setting some variables between the two, but are you wanting something like this?


    Sub CreateTableOfContents()
    ' Determine if there is already a Table of Contents
    '...
  22. Re: How to fix : vba runtime error 1004 application defined or object defined error

    It's possible it could be something with the sheet. For example, if you add a lot of rows, the program could eventually consider the end of your "used" range to be the last row on the sheet--even if...
  23. Re: How to fix : vba runtime error 1004 application defined or object defined error

    Well, you could just take out the Select statements entirely. You don't have to select a cell in the column to change the column width. Actually, you should be able to rewrite this entire macro to...
  24. Replies
    5
    Views
    398

    Re: macro-ize these manual key strokes

    Would this work for you?


    Dim C As Range, rngB As Range
    'loop through visible rows
    For Each C In Columns("G:G").SpecialCells(xlVisible)
    'if value is not XXX
    If C.Value <> "XXX" Then...
  25. Replies
    4
    Views
    44,138

    Re: Lost Pivot table toolbar

    Assuming you are using Excel 2007 or 2010, have you selected an area within the pivot table? That will bring up the context tab for Pivot Tables on the ribbon.

    If you closed the field pane that...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4