New answers tagged excel
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
...
- 981
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'....
- 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 ...
- 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 ...
- 625
Top 50 recent answers are included