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
    2013 MBA 13" - OS X 10.12.latest & 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