Thread: Address of Merged Cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default Address of Merged Cells
Option Explicit
Sub testme()

MsgBox ActiveSheet.Range("a1").Address
MsgBox ActiveSheet.Range("a1").MergeArea.Address

End Sub

Will return different values.

"pgjoshi <" wrote:

I have merged cells from A1 to A7. When I activate the merged range the
address list shows A1. I want the the total address of the merged range
i.e. A1:A7 through VB. (Activecell.address shows A1 ) Can anyone help
me ?

Prasad Joshi

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

Reply With QuoteReply With Quote