Posts by Edelson • 33 points
2 posts
-
1
votes4
answers11775
viewsA: Dynamically set the Excel column size
try: Worksheets("Plan1").Columns.AutoFit or 'A:I can be replaced by the range you want. Worksheets("Plan1").Columns("A:I").AutoFit…
-
2
votes1
answer256
viewsQ: How to remove a Label that was created dynamically in VBA?
The code below, sent by Luiz Vieira, creates Labels dynamically and a click treatment function for each Label. I would like to know how to use the Click event to remove the dynamically created…