I am trying to write a macro that will fill a range automactically, but the range will vary and does not remain static. A user needs to be able to define the range by using a button. Any suggestions as to the best approach!
Thanks in advance
Thanks in advance