Help please

clares · Mar 15th, 2002, 03:01 AM

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

Mar 15th, 2002, 04:13 AM

Quote:

On 2002-03-15 02:01, clares wrote:
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

"fill a range automactically"
What do you want to fill it with?

"user needs to be able to define the range by using a button"
Do you mean that the user will supply the range to be filled via, for example, an input box?

clares · Mar 15th, 2002, 04:16 AM

I have re-written the question an titled it "Autofill a range" Any chance that you could view that question!

Thank you

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 03:01 AM	#1
clares Board Regular Join Date: Mar 2002 Location: Portsmouth.UK Posts: 543	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

Mar 15th, 2002, 04:16 AM	#3
clares Board Regular Join Date: Mar 2002 Location: Portsmouth.UK Posts: 543	I have re-written the question an titled it "Autofill a range" Any chance that you could view that question! Thank you