Why isn't this working?
MsgBox Worksheets(1).Range("A12").Borders.Parent.Name
Shouldn't the Message Box display A12 since the Range object is a parent to the borders object?
Why isn't this working?
MsgBox Worksheets(1).Range("A12").Borders.Parent.Name
Shouldn't the Message Box display A12 since the Range object is a parent to the borders object?
A12 isn't a name its an address.
e/ although if you know the range I'm not sure where that gets you.![]()
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks