Select a single line even if there are merged cells with VBA
Closed
Jerry
-
Aug 17, 2016 at 03:39 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 25, 2016 at 11:39 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 25, 2016 at 11:39 AM
Related:
- Vba select merged cells
- Vba select case like - Guide
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Lg tv setting select mode - Guide
- Excel vba select last sheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 25, 2016 at 11:39 AM
Aug 25, 2016 at 11:39 AM
Hi Jerry,
Merged cells don't work well with VBA. You will have to start your code by unmerging first then finish the code by merging the cells again.
Best regards,
Trowa
Merged cells don't work well with VBA. You will have to start your code by unmerging first then finish the code by merging the cells again.
Best regards,
Trowa