Results 1 to 3 of 3
  1. #1

    Member Since
    Sep 20, 2012
    Works on Windows not on my Mac
    Can someone help me get this to work on a Mac?
    Sub LastBorderedRowNumber()

    Dim LastCellWithBorder As Long
    Const ColumnLetter As String = "A"
    Application.FindFormat.Borders(xlEdgeBottom).LineS tyle = xlSolid
    LastCellWithBorder = Columns("A").Find("*", SearchDirection:=xlPrevious, SearchFormat:=True).Row

    ' Let just see what we calculated
    MsgBox "Last bordered cell in Column " & ColumnLetter & " is on Row " & LastCellWithBorder
    End Sub

  2. #2

    McBie's Avatar
    Member Since
    Apr 26, 2008
    iPad Pro 12.9 latest iOS
    This is not related to any OS in particular.
    The correct functioning of this routine depends on the application you are running it in ( Visual Basic, Excel macro, ..... )

    What application are you developing/testing this in ?

    Cheers ... McBie
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.
    The bitterness of poor quality remains long after the sweetness of low price is forgotten.

  3. #3

    Member Since
    Sep 20, 2012
    Sorry , new at this. This was for an Excel for Mac macro. Have since found that the application.find function has been eliminated in Excel for Mac. No one knows why. I will do a for loop instead. Thank you for your response.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. windows xp on a mac, nothing works, drivers ?
    By viezu in forum Running Windows (or anything else) on your Mac
    Replies: 3
    Last Post: 03-08-2011, 02:25 PM
  2. How does Windows 7 works with Mac? 1 key issue
    By larsingedude in forum Running Windows (or anything else) on your Mac
    Replies: 5
    Last Post: 05-05-2009, 09:52 PM
  3. Running Bootcamp, Windows works Mac doesn't
    By smallstech in forum Running Windows (or anything else) on your Mac
    Replies: 3
    Last Post: 02-07-2009, 12:05 AM
  4. Replies: 1
    Last Post: 01-06-2009, 08:38 PM
  5. External Drive works for windows but not Mac. Issue.
    By Quixotic Dreams in forum Other Hardware and Peripherals
    Replies: 7
    Last Post: 03-21-2008, 04:18 PM

Posting Permissions

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