Thread: Assemble a destination_range for auto-filling a formula
View Single Post
 
Old 11-20-2015, 07:15 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
  
Join Date: Oct 2015
Posts: 87
Officer_Bierschnitt is on a distinguished road
Default
OK,

I've made it. A bit of a detour probably as I used a formula written to the worksheet - but it works.

Ah. Debaser, I hadn't seen your post just now. Yes, that would be one step easier than what I did - I generated the exact cell reference (like L32) and then created a string_variable like > L2:L32 < that I could then put in the brackets.
Last edited by Officer_Bierschnitt; 11-20-2015 at 07:17 AM. Reason: just seen a new answer
Reply With Quote