Posts by Edelson • 33 points

• 1

  votes

  4

  answers

  11775

  views

  A: 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…

  excel vba

  answered 8 years, 4 months ago Edelson 33

• 2

  votes

  1

  answer

  256

  views

  Q: 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…

  vba label

  asked 8 years, 5 months ago Edelson 33