Forum Home
Press F1
Thread ID: 21751	2002-07-03 04:16:00	Excel	John Robb (825)	Press F1

Post ID	Timestamp	Content	User
59389	2002-07-03 22:36:00	Many thanks Russell, That works well. Is it possible to get the Macro to paste the result into a specific cell? That would really put the cream on the coffee Thanks john	John Robb (825)
59390	2002-07-03 22:39:00	Thanks for your help Wuppo, Russell's effort works well and is probably simpler for me to implement as I am used to using Macros but not visual basic code although I think they are pretty similar. Thanks for your help anyway John	John Robb (825)
59391	2002-07-03 22:48:00	To enter the result into a cell. Comment out the MsgBox x line (or delete it) and add the following line. Range("nn").value = x Edit the nn to the cell you want eg B3 Cheers	Russell D (18)
59392	2002-07-03 23:22:00	Many thanks Russell, I have assigned it to a button and it works brilliantly. Makes life much easier now Regards John	John Robb (825)
1 2