Which is faster copy & paste special/transpose or defining 35 variables?
I have a database in excel
Column A is the ID. Columns B-AJ are criteria relating to the ID in column A
My procedure finds a specific ID in Column A and copies the data from the adjacent 35 columns (B-AJ) to another form
The first (5) (B-F) I used variables because their destinations are scattered about the form
The next (12) I used copy & paste special/transpose because the destination on the form is adjacent rows in one column
The next (6), next (6) and next (6) I also used copy & paste special/transpose because the destination on the form is adjacent rows in three non adjacent columns
Other than speed are there pros & cons to copy & paste special/transpose versus variables?
Bookmarks