Hello
Just a small help required.
Currently I have textboxes where i input data of which row, column etc
I would like to change it using the refedit option so that it becomes easier
Have attached a dummy file for reference
As you will see when the Userform loads that I have already put the default values as 2, 12, and 5 in a text box
2 and 12 referes to the rows
and 5 refers to the column E where the data will be picked up from
Now instead of entering numbers such as 2,12,5 I was wondering if i could just select the data validation range (ie. $E$2:$F$12) by inserting a refedit (instead of having textboxes) and use the values which I get from it
ie. use the value "2" and "12" and "E" from the range
Also in the first refedit box where i select 'B3' would it be possible to prevent me from selecting a range. (ie only a single cell should be selected not a range)
Thank you.
(If you want to run the macro you have to put 'B3' in the Ref edit input box and after you press ok select a folder where you want to save your outputs)
Bookmarks