Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.38 seconds.

  1. Re: 'Range' of object '_Global' failed ---runtime error 1004

    Fluff's code works fine for me using the data you posted, provided that I change the Find Method line to this:



    Set MaxCell = zoomRng.Find(169.875, LookIn:=xlFormulas, lookat:=xlWhole,...
  2. Replies
    2
    Views
    65

    Re: multi criteria multi result lookup

    Copy AM7 down.
    <b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; ...
  3. Re: Positioning Subtotals to the next column on right

    Using VBA, what you want could be done with a button click. If you are willing to use VBA, post a small sample of your starting data/layout, and indicate which columns you want to subtotal and what...
  4. Replies
    5
    Views
    98

    Re: Change how date is converted.

    You are welcome - thanks for the reply.
  5. Replies
    5
    Views
    98

    Re: Change how date is converted.

    If your regional date system follows a "dd/mm/yyyy" format you would enter November 3, 2019 as: 3/11/2019.

    My regional (US) format is "mm/dd/yyyy" so November 3, 2019 would be 11/3/2019 here.
  6. Replies
    2
    Views
    54

    Re: Check If Cell Not Empy in Multiple Rows

    Assuming the header data1 is in A1, then in E2 and copy down:


    =IF(COUNTA(A2:D2)>0,"ok","no")

    Also assumes "empty" cells are truly empty and not containing a formula that returns "" (null...
  7. Replies
    3
    Views
    71

    Re: Updating a formula in excel

    Holidays is a named range that holds the dates of all public holidays for the current year or the year pertinent to the range of dates that might be entered in cell A11.

    ...
  8. Re: Upon selection of item in table row, need msg box to appear and have resulting number entered in table

    This is sheet code for a change event. Right-click the sheet tab, choose "View Code" and paste the code below into the VBE window that opens.


    Private Sub Worksheet_Change(ByVal Target As Range)...
  9. Thread: Count If

    by JoeMo
    Replies
    4
    Views
    93

    Re: Count If

    Maybe Sheet1 should be Sheet3??
  10. Re: VBA Error window has changed - no more Debug button

    Seems that way, and explains why I have never noticed it as my sheet modules are almost exclusively event procedures.
  11. Re: VBA Error window has changed - no more Debug button

    In that case I get the OK-Help dialog, not the debug button, regardless of whether the sub is Private or not.
  12. Re: VBA Error window has changed - no more Debug button

    Hmm, I get the debug button if I run that from a selection_change sheet module, or a standard module with the "Break on unhandled errors" setting. XL2010, Win10.
  13. Replies
    10
    Views
    126

    Re: Change background color of all named ranges

    Even better - thanks for that Mike.:)
  14. Re: VBA Error window has changed - no more Debug button

    It's been set on "Break on unhandled errors" from the start of my sometimes futile attempt to learn VBA. :laugh:

    Another good catch Fluff - thanks!
  15. Replies
    10
    Views
    126

    Re: Change background color of all named ranges

    Here's my cursory attempt to combine all the knowledge imparted by the previous posts to arrive at something more robust:


    Sub testdata()
    Dim nm As Variant
    For Each nm In ThisWorkbook.Names
    ...
  16. Re: VBA Error window has changed - no more Debug button

    See post #33
  17. Re: VBA Error window has changed - no more Debug button

    Fluff, are you indicating that the "Break in class module" button should be filled? Its not for me and I get the "Normal" dialog boxes.
  18. Re: VBA Error window has changed - no more Debug button

    I get a debug error with that.
  19. Replies
    10
    Views
    126

    Re: Change background color of all named ranges

    If you open the Name Manager you can filter for names with errors and delete them. From what you show above it seems the name was on a sheet that's no longer part of the workbook.
  20. Replies
    10
    Views
    126

    Re: Change background color of all named ranges

    When that error occurs, I assume it highlights the Range(....) line, open the Immediate Window and type:?nm.Name then press enter. If that returns a name, then type: ?nm.RefersTo and press enter....
  21. Replies
    10
    Views
    126

    Re: Change background color of all named ranges

    First, nm.refersto includes an equal sign which you have to eliminate to create a legal string address. Also, sometimes worksheet function errors cause Excel to generate hidden names you don't know...
  22. Re: VBA Error window has changed - no more Debug button

    Interesting that if I run anything that causes an error from the Immediate Window it generates a msgbox-type error (OK, Help) , while creating the error within a procedure I get the usual runtime...
  23. Re: VBA Error window has changed - no more Debug button

    I get the debug run time error dialog box when I run the sheet code below.


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim R As Long
    'Next line generates runtime error if the...
  24. Replies
    12
    Views
    97

    Re: Print selection code doesn't work properly

    Try selecting the area you want to print, then run the code from post #3 .
  25. Re: Help! Consolidating rows across columns with duplicate names!

    You are welcome. Follow the steps below to install and run the code.
    To install standard module code:
    1. With your workbook active press Alt and F11 keys. This will open the VBE window.
    2. In the...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4