Thread: Problem finding merged cells
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default Problem finding merged cells
RBS,

If IsNull (RangeObject.MergeCells) or RangeObject.MergeCells then
MsgBox "Unmerge cells and try again. "
Exit Sub
End if
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"RB Smissaert"

wrote in message
All I want to do is determine if the sheet has merged cells or not.
It looks there somehow is a bug with FindFormat.
RBS,




Reply With QuoteReply With Quote