New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Works on Windows not on my Mac


Post Reply New Thread Subscribe

 
Thread Tools
anwaee2

 
Member Since: Sep 20, 2012
Posts: 6
anwaee2 is on a distinguished road

anwaee2 is offline
Can someone help me get this to work on a Mac?
Sub LastBorderedRowNumber()

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

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

 
McBie's Avatar
 
Member Since: Apr 26, 2008
Location: Belgium
Posts: 2,290
McBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to all
Mac Specs: 2013 MBA 13" - 10.9.3 & iPad - iOS 5.1

McBie is offline
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 problem is not the problem. The problem is your attitude towards the problem. You understand ?
QUOTE Thanks
anwaee2

 
Member Since: Sep 20, 2012
Posts: 6
anwaee2 is on a distinguished road

anwaee2 is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Time Machine Disk Backup Size | Lost my Aplications folder? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Mac Startup disk can't see windows 7 partitition Justelis Running Windows (or anything else) on your Mac 8 04-21-2012 04:21 PM
P.C. user on a MAC, help dispel my hatred kdubbie Switcher Hangout 20 05-10-2011 06:23 PM
Windows 7 Paulo OS X - Operating System 2 05-18-2010 06:48 PM
Running Windows on my iMac! BlindingLights Running Windows (or anything else) on your Mac 27 04-19-2006 05:40 PM

All times are GMT -4. The time now is 01:47 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?