Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Printing to another printer than the default printer

    Hi and welcome to Mr. Excel!

    This is an oft-asked question on this board.
    May I suggest that you do a search for "NE" and "printer." A bit of leg work will throw up a who;e host of similar posts...
  2. Replies
    4
    Views
    113

    Re: Hide rows based on drop down list

    Hi and welcome to Mr. Excel!

    This is a very common question, and the idea here, is to do a search for similar questions; if you can't find anything, then post.

    I did a quick search for you, and...
  3. Thread: Auto saving date

    by sykes
    Replies
    2
    Views
    98

    Re: Auto saving date

    Depends - how about posting your macro?
  4. Replies
    8
    Views
    270

    Re: Loan repayment calculation

    PMT? https://exceljet.net/formula/calculate-payment-for-a-loan
  5. Replies
    10
    Views
    168

    Re: VBA hiding rows seems slow any ideas?

    What about if you only did one test i.e. for a string of "0" rather than = 0 AND <> 0? :
    Sub HideRowsOnSheet()
    Dim i As Long
    Application.ScreenUpdating = False
    For i = 10 To 122
    ...
  6. Re: Macro to reset column to first item in data validation drop down list

    Hi, and welcome to Mr. Excel!
    It's often that case that you want to upload a copy of just part of your worksheet (selected cells/whole table etc), as a picture really is worth a thousand words.
    ...
  7. Replies
    2
    Views
    60

    Re: Creating separate workbooks using a macro

    Hi, and welcome to Mr. Excel!

    Yes, you can do this.

    Suggest that, rather than create extra new posts for this sort of thing, use the excellent search facility - there are literally 100s of...
  8. Re: Use Date Picker to Locate and Select a Cell

    Obviously, change the sheet ref & DTPicker name, to suit...
    Private Sub DTPicker1_Change()
    Dim cl As Long
    Dim lstrw As Long

    On Error GoTo exit_sub
    With Sheets("Sheet11")
    lstrw =...
  9. Replies
    3
    Views
    122

    Re: Excel close on Userform Termination

    Hi, and welcome to Mr. Excel!
    Can you temporarily disable all code running, by setting the macro security to "high" or stopping all code running, then open the problem workbook that way?
  10. Replies
    4
    Views
    103

    Re: Trying to get rid of select

    Not sure about your actual code, but ...

    Rather than "select, cut and paste", try to use the syntax One.thing=Another.thing
    For example,
    Sheets("Sheet1").Range("C5").value =...
  11. Re: Set Lrow by dialog box? & Loop batch size limit

    Pleasure! Thanks for the feedback.
  12. Re: Set Lrow by dialog box? & Loop batch size limit

    Can't comment on the reliability, but as for the lrow...

    lrow = InputBox("Enter the list number!")
    MsgBox lrow Msgbox is just to demo output of inputbox.
  13. Re: VBA - Extract data by matching value - error

    Good find!
    Thanks for closing out your post.
  14. Re: VBA - Extract data by matching value - error

    Works for me, too (with a couple of "0"s in the previously activesheet, Column L).
    Could it be that you wanted to count cells <> 0, rather than =0?
  15. Re: VBA - Extract data by matching value - error

    Disregard previous post - looks like you DID want to search the previously active sheet...
  16. Re: VBA - Extract data by matching value - error

    You've set ans to the old activesheet, so it's looking in whatever the activesheet was BEFORE you added the new sheet.
    Try:
    Dim lastrow As Long
    Dim c As Long
    Dim s As Variant
    Dim ans As String
    ...
  17. Thread: Formula Too Long

    by sykes
    Replies
    6
    Views
    204

    Re: Formula Too Long

    saffo5
    Did any of these suggestions help you?
  18. Thread: Formula Too Long

    by sykes
    Replies
    6
    Views
    204

    Re: Formula Too Long

    Having (finally) just got 'round to trying out the HTML maker, I thought I'd put it to its first bit of good use, so here's a better representation of my solution:

    <b></b><table...
  19. Replies
    2
    Views
    80

    Re: Looking for a formula

    Hi, and welcome to Mr. Excel.
    This looks like either homework, or an assignment - which should be carried out by the individual.

    Neither columns 2 nor 3 can be filled without more data being...
  20. Thread: Formula Too Long

    by sykes
    Replies
    6
    Views
    204

    Re: Formula Too Long

    I was just playing around with this.
    I started a new sheet, and put this mini table into A1:G7:

    CCT BBA TYR YTP GVW ABQ
    CCT - 65 12 3 5 4
    BBA 800 - 24 31 0 5
    TYR 1 2 - 4 5 6...
  21. Thread: Formula Too Long

    by sykes
    Replies
    6
    Views
    204

    Re: Formula Too Long

    Hi, and welcome to Mr. Excel!
    Likewise, I wouldn't try to use a huge formula for this; I was thinking of making a table on a separate worksheet, with the city codes along the top row, and down the...
  22. Re: ActiveX Combobox.matchentry not working for last item in dropdown list

    Can't see where your problem comes from - bit of an odd one, that...
    However... wouldn't it be a lot simpler to just put the worksheet_activate call, directly into the ComboBox's _click event? ...
  23. Replies
    5
    Views
    144

    Re: How to clean up overflow text.

    Jolly good - glad it worked for you.
    With a bit more code, you can easily change the font/size etc, too.
  24. Re: Pass Worksheet_Change Target Value to Userform

    How about declaring a public variable (as long) then setting that to the row number during the w/s_change event...
    Dim rw as long
    rw = Target.Row ...then calling rw when you need it?
    Private Sub...
  25. Re: Highlite drop down selection in existing working code

    Pleasure!
    Glad it worked, and thanks for the feedback.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4