Thread: Random Clears
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ducky ducky is offline
external usenet poster
 
Posts: 27
Default Random Clears


Andy B wrote:
Office 2003 Pro

I have a table of ten rows and ten columns.

I want to clear a random cell on loading.

And then I want to add a button the the sheet which would activate this
function at the users will.

Any Ideas?

TIA GWB


make a program that chooses two random numbers - each between 1-10,
then use the randomly generated numbers to point to an R1C1 address,
embed the button and have it call the same code.