The vba tag has no wiki summary.
0
votes
1answer
11 views
Range or Row and Column Indices in VBA
I would like to know what the pros and cons are for storing a range variable instead of four integers or long variables (representing the first and last row and column) to define that range. One ...
3
votes
0answers
366 views
Implement FBP / Dataflow programming in VBA?
Intrigued by Flow Based Programming a la J Paul Morrison. I wonder if one can implement FBP in Excel/VBA. I searched quite a bit for a Basic-Lang FBP implementation to no avail. I've looked at some ...
1
vote
0answers
216 views
Excel: Vba Copy and paste efficiency with 000's of rows and columns
Hey guys so I'm sure this is probably out there but I can't seem to find it.
Updates
I have tested some different code, and reduced my time to complete the task from 50/60 seconds to 10 seconds. ...
