Results 1 to 14 of 14

Getting run-time error 424 object require

Threaded View

mso3 Getting run-time error 424... 08-27-2015, 07:13 AM
TMS Re: Getting run-time error... 08-27-2015, 07:45 AM
mso3 Re: Getting run-time error... 08-27-2015, 08:52 AM
TMS Re: Getting run-time error... 08-27-2015, 10:19 AM
mso3 Re: Getting run-time error... 08-27-2015, 11:09 AM
TMS Re: Getting run-time error... 08-27-2015, 01:16 PM
mso3 Re: Getting run-time error... 08-27-2015, 08:00 PM
TMS Re: Getting run-time error... 08-28-2015, 07:22 AM
mso3 Re: Getting run-time error... 08-28-2015, 08:52 AM
TMS Re: Getting run-time error... 08-28-2015, 09:38 AM
mso3 Re: Getting run-time error... 08-28-2015, 10:12 AM
TMS Re: Getting run-time error... 08-28-2015, 11:00 AM
mso3 Re: Getting run-time error... 08-28-2015, 12:18 PM
TMS Re: Getting run-time error... 08-28-2015, 01:15 PM
  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Getting run-time error 424 object require

    Hi friends,

    I want to create inner and outer border macro to avoide repeated job and save time.
    I’m getting run-time error 424 object require error.

    Option Explicit
    
    Sub Borders()
    
    Dim OB As Variant
    OB = InputBox("enter cell number to border around")
    Dim IBV As Variant
    IBV = InputBox("enter cell number to border inside")
          Dim IBH As Variant
    IBH = InputBox("enter cell number to border inside")
    
    'Outer border
    With OB
    .CurrentRegion.BorderAround Color:=-6279056, Weight:=xlThick, LineStyle:=xlSlantDashDot
    End With
    
    'Inner border
    With IB
    .CurrentRegion.Borders (xlInsideVertical)
            .LineStyle = xlContinuous
            .ColorIndex = xlAutomatic
            .Weight = xlThin
        End With
        
    With IB
        .CurrentRegion.Borders (xlInsideHorizontal)
            .LineStyle = xlContinuous
            .ColorIndex = xlAutomatic
            .Weight = xlThin
        End With
    
    MsgBox "Done!", 64
    
    End Sub
    Any help will be highly appreciated.

    Thanking you in anticipation.
    Last edited by mso3; 08-27-2015 at 07:17 AM.
    Sincerely,

    mso3

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Getting compile error 424 object require
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2015, 10:27 PM
  2. [SOLVED] Sort Macro Run-time error '1004': Application/Object-defined error.
    By sam1212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2014, 10:05 AM
  3. Getting error 424 object require
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2014, 12:06 AM
  4. [SOLVED] Getting error 424 object require
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-09-2014, 04:53 AM
  5. Replies: 7
    Last Post: 05-15-2013, 09:02 AM
  6. [SOLVED] object require error
    By necalabria in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-26-2012, 08:46 PM
  7. [SOLVED] run-time error '1004': Application-defined or object-deifined error
    By rich5665@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1