New answers tagged

2 votes

Add padding to top and bottom of cells

First of all I would replace this With rng.Rows .WrapText = False .AutoFit .WrapText = True .AutoFit End With with just this ...
user avatar
2 votes
Accepted

Identify Anonymous orders in BOM list & update accordingly, execute time is taking very long

The code cycles thru the remainder of dArray even after meeting the logic condition for setting an mArray element to 'Anonymous'....
user avatar
  • 953
1 vote

VBA - Compare & Consolidate Dynamic Arrays

A well-known code development aphorism is "Make it work. Make it right. Make it fast" (Kent Beck). The most nebulous statement here is "Make it Right". I would propose that ...
user avatar
  • 953
0 votes

VBA - Compare & Consolidate Dynamic Arrays

The structure of your code would suggest that your chances of being recognised as a developer are practically zero. You have many functions encapsulated in a single method. Split your Method into ...
user avatar
  • 625

Top 50 recent answers are included