View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carrie Carrie is offline
external usenet poster
 
Posts: 68
Default merging cells using VB - Excel 2003

I have a row of 1's and 0's. I would like to merge all the cells with 1's
that are grouped in a row and not merge the 0's.

Example:

1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 1 1 1 1 1 1

So that the cells with 1's in them merge and the cells with 0's in them do
not merge.

Is is possible?

Thanks in advance
Carrie