paul bica

paul bica has asked 3 questions and find answers to 20 problems.

Stats

About

Over the years I found amazing vba solutions here

I'd like to help if I can - minimal questions are most effective

SOReadyToHelp

Email dexxus@rogers.com

paul bica questions

Excel VBA Performance - 1 million rows - Delete rows containing a value, in less than 1 min

paul bica answers

How make concatenate function faster
How do I run a Stored procedure with parameters from Excel VBA string?
Copy and paste information based on matching IDs where one sheet has rows in the pivot table
How to connect to OPEN workbook in another instance of Excel
Two dimensional array as item of dictionary
Excel Macro: Copying row values from one worksheet to a specific place in another worksheet, based on criteria
Excel - Close/Save using full path name
How do I concatenate cell values and text together using Excel VBA?
Excel VBA Performance - 1 million rows - Delete rows containing a value, in less than 1 min
VBA - Username of open workbook (read only)