Hi all,
I have created a macro that will automatically populate a column with all variations of a keyword including a space. There are 4 additional columns with standard values which I would like to have my macro copy down for all populated cells in the list. I'm struggling however to define the range for which to copy these values, given that the length of the range for which to copy varies.
In the attached example, there are now 5 values in the column on the left, but this could also be 10 values, 15, 18, etc. (in other words it varies) What I'm looking for specifically is that if I run the macro, it will copy the contents of the selected cells down, up and until the last row of the list of keywords. In the example that would mean up and until the row of 'Example 4' This would normally done be done by double-clicking the small box on the bottom right, but I need to know how to do this in VBA code
Is anyone able to help me with defining this variable range as well as the expression to copy the values down subsequently?
THanks a lot!
Addition:
I have a gut feeling it will be something like
, where Z8 is the variable value (e.g. the countblank of V3:V258 - the max number of values generated is 255)
Example.JPG
Bookmarks