PDA

View Full Version : Sleeper: VBA code to un-merge cells from a Database



Farid_97
06-13-2023, 11:00 AM
How to create a command in VBA to unmerge cells from a data base (ERP)?
Thank you

June7
06-13-2023, 11:29 AM
Try using macro recorder to generate basic code and modify to suit your particular requirements.

Aussiebear
06-13-2023, 12:03 PM
Welcome to VBAX Farid_97. Hope you don't mind but I have edited your thread to more accurately reflect the intent of the Question posed.

Aussiebear
06-13-2023, 12:08 PM
You could try something like this



Sub UnMergeRange()
Range("A1:B3").UnMerge
End Sub


Since we don't know what the range is, and you didn't mention it either, this is just an example. Change the range to suit.

June7
06-13-2023, 12:11 PM
Aussie, for some reason CODE tags not working in your post.

And now they are after refreshing page - although two font sizes used.