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
...
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'....
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 ...
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 ...
Top 50 recent answers are included
Related Tags
excel × 1096vba × 880
performance × 271
beginner × 85
python × 79
c# × 62
object-oriented × 39
array × 37
time-limit-exceeded × 25
error-handling × 25
python-3.x × 21
sql × 21
csv × 21
web-scraping × 20
java × 19
pandas × 17
file-system × 15
algorithm × 14
datetime × 14
ms-access × 14
sorting × 13
hash-map × 13
rubberduck × 12
ms-word × 12
python-2.x × 10