I have already done the above question, BUT when i exit design mode and hit
the button to initiate the macro, i have the following error:

run-time error '1004':
Select method of Range class failed

Then i click on 'Debug': it takes me to Visual Basic and highlighted is the
line with the range details.

Please help, i need to setup this workbook as soon as possible
u may even call me 07947312289 (UK)

Regards

An excel Nut

Hi

if you post your code, i'm sure an answer can be found.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"An Excel Nut" <An Excel wrote in message
...
I have already done the above question, BUT when i exit design mode and hit
the button to initiate the macro, i have the following error:

run-time error '1004':
Select method of Range class failed

Then i click on 'Debug': it takes me to Visual Basic and highlighted is
the
line with the range details.

Please help, i need to setup this workbook as soon as possible
u may even call me 07947312289 (UK)

Regards

An excel Nut