I posted a question yesterday and was not able to get a successful solution to my problem. Upon further research, I think my solution lies in using a 'Variant Object' to copy a formula across a large data range "in bulk" to Excel memory---then when finished, copy back into the worksheet. Is anyone familiar with this process that can help me? Here are the specifics:
Formula that needs to be copied is located in range: AE2:AZ2
Range it needs to be copied against: AE5:AZ-- *ending row depends on how much data exists in file. Data is populated in range: A5:AD--
So basically, I'd like to create this variant object to copy the formula into all "data" rows based on the amount of data in the file. (NOTE: The formulas depend upon the data to get the result, so assume the data must also be copied into this variant object so the calculations will work correctly??) Any help would be greatly appreciated!!
Formula that needs to be copied is located in range: AE2:AZ2
Range it needs to be copied against: AE5:AZ-- *ending row depends on how much data exists in file. Data is populated in range: A5:AD--
So basically, I'd like to create this variant object to copy the formula into all "data" rows based on the amount of data in the file. (NOTE: The formulas depend upon the data to get the result, so assume the data must also be copied into this variant object so the calculations will work correctly??) Any help would be greatly appreciated!!