Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.15 seconds.

  1. Replies
    12
    Views
    595

    Re: Userform Overdue Calculation

    Is the code in post 8 on the userform?
    Is cboStart on the userform?

    If both are true then the error you mentioned in post 8 should not happen because Me.cboStart would be OK

    I thought the...
  2. Re: Can't copy and paste after using VBA code. Any help please

    If you use the 2 buttons then you can remove the Worksheet_SelectionChange code and the copy/paste problem should go away.
  3. Replies
    12
    Views
    595

    Re: Userform Overdue Calculation

    That error is usually caused by using the me qualifier when the code is located in a standard or class module.
    On a worksheet or chart code page me it taken to mean that page
    In a form's codepage,...
  4. Re: Can't copy and paste after using VBA code. Any help please

    I could not figure out a way to let you copy and paste as long as the code was triggered by selection change and you wanted to clear A4 whenever. See if this code with 2 ActiveX command buttons will...
  5. Re: Can't copy and paste after using VBA code. Any help please

    I tested the code with my modification by copying a cell inside the D22:I46 range and pasting it outside of that range.
    I also tested copying a cell outside of that range to another cell outside...
  6. Re: VBA for verifying whether a specific worksheet and cell have data or not

    Glad to help
  7. Replies
    1
    Views
    189

    Re: Need formula for Point spread

    Figuring out the split after the fact will only cause dissent among the 4 involved and any other employees. Since it was not decided prior to the results, I would give each 75 points.

    Determining...
  8. Re: Can't copy and paste after using VBA code. Any help please

    Change

    Range("A4").ClearContents
    to

    Range("A4").Value = vbNullString

    Excel copy (from a cell) & paste (to a cell) relies on the first cell still having the "marching ants" effect...
  9. Re: Search Folder For Docs With Key Words

    If you are searching for key words in the file content rather than the file path or name then you would be better served using explorer. The following code will return a list of files in a folder...
  10. Re: how to retrieved my data in worksheet to my combo box ??

    In the first code you have an ActiveX combo box and you assign to it the value in BH3.
    In the second code you assign the value in the combo box to CV3
    I assume by your title you want to add...
  11. Re: Macros to Sort, Insert rows then copy and paste formulas only form cell ranges to worksheet

    Please provide a few lines of the dispatch worksheet before the code is run, be sure to state what worksheet rows they are in.
    What row on that worksheet contains the headers? What is the last...
  12. Replies
    3
    Views
    115

    Re: Dynamic Chart help Excel 2007

    If the Weekly Average column (DCP) is left in and the next week's data starts in column DCQ then I don't see a simple way to show (or compare several months of that data without the weekly average...
  13. Re: VBA for verifying whether a specific worksheet and cell have data or not

    Add this code immediately above the End Sub statement


    If Worksheets("wk 53").Range("A2").Value <> vbNullString Then
    MsgBox "There is a carry over year end date. Check Tab: wk 53 for...
  14. Replies
    3
    Views
    115

    Re: Dynamic Chart help Excel 2007

    I believe this will do it:
    ...
  15. Replies
    4
    Views
    214

    Re: Complex Distance Formula

    300 x 4000 = 1,200,000
    Implementing the comparison in code might be more efficient

    What is the source of your formula? I was thinking https://en.wikipedia.org/wiki/Haversine_formula but that...
  16. Replies
    4
    Views
    214

    Re: Complex Distance Formula

    What do you mean by "flip it around"? Please explain your setup for 4K vs 300 and 300 vs 4K.
  17. Re: Auto save multiple accounts from one sheet - Simplify

    Glad it's working.
    The .autofit line is what is setting the column widths after each save. Remove it.
    Also, selecting is not necessary for most VBA actions and it slows processing a bit. Change...
  18. Re: Auto save multiple accounts from one sheet - Simplify

    I did not notice your headers started in row 11. Also added a few reporting lines. Try revised code.


    Option Explicit

    'I chose not to use command buttons since you would have to create 100...
  19. Re: check for duplicate in excel table before adding new

    Guesses below since there is not enough info provided to be sure.

    See comments in code:


    Option Explicit

    Private Sub AddReturn_Click()

    'No variables declared, added for clarity
  20. Re: Auto save multiple accounts from one sheet - Simplify

    Corrected error. Try it again.

    If you have to copy sections of code multiple times (110 !!!!) there is almost always an easier way to perform that function.


    Option Explicit

    'I chose not...
  21. Re: Auto save multiple accounts from one sheet - Simplify

    I did not test this because I did not want to set up a bunch of files to process, but step through the code on a COPY of your workbook to see how it works.
    Let me know if any problems arise.

    ...
  22. Re: Autofilter omitting some columns and I can't work out why

    Is there any VBA code in the workbook that could account for the autofilter being changed?
    Does "merrily using" include column deletions or additions?
    I have noticed with Excel 2016 there are...
  23. Re: All Combinations of Multiple Columns Without Duplicates

    A bit more code to ensure the salary worksheet contains valid numbers, does not have duplicate names and has a name for each entry in the grid on the main worksheet. Read notes in the code.


    Sub...
  24. Re: VBA to generate hyperlink to new sheet and assign to shape

    Glad to help. Thanks for feedback.
  25. Re: VBA to generate hyperlink to new sheet and assign to shape

    Modify the indicated one line of your code and add the lines marked as new lines .


    Option Explicit

    Sub AddShapeWithhyperlink()

    Dim mySheetName As String ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4