Hello I have A Problem And I Need A Solution Quickly, I Have A Button Which When Clicked I Want To Do The Follwoing Things
->Copy A Selection Of My Cells from 'A1' to 'G49' (I Have Also Named These cells a range called 'export1' Onto A New Workbook
->Have This New Workbook Automatically Saved While And Then Have To Workbook Closed
When This Has Been Done 250 Times I Would Like A Message Box To Come Up Saying A Customised Message
I Need All The VB Code For This Please Help Me!
->Copy A Selection Of My Cells from 'A1' to 'G49' (I Have Also Named These cells a range called 'export1' Onto A New Workbook
->Have This New Workbook Automatically Saved While And Then Have To Workbook Closed
When This Has Been Done 250 Times I Would Like A Message Box To Come Up Saying A Customised Message
I Need All The VB Code For This Please Help Me!