you cant have Cells(c, 0).
the first column "A" is index 1
use the following code instead:
![]()
Range(Cells(c,1), Cells(c + nRows - 1, 2)).MergeCells = True
you cant have Cells(c, 0).
the first column "A" is index 1
use the following code instead:
![]()
Range(Cells(c,1), Cells(c + nRows - 1, 2)).MergeCells = True
Regards,
Khaled Elshaer
www.BIMcentre.com
Remember To Do the Following....
- Thank those who have helped you by clicking the Star below their post.
- Mark your post SOLVED if it has been answered satisfactorily:
- Select Thread Tools (on top of your 1st post)
- Select Mark this thread as Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks