Posts by homer

All the cells are one sheet and only changing values. Wil lthe reformat then change all the values to be in euros? How do I use reformat?

Thanks.

How do I change all my GBP (sterling) fileds to Euros in one hit? Rather then going through each cell at a time?

Thanks.

Thanks. Tried that but nothing seems to happen do i need to compile or run something...?

Thanks, again.

What about just a work-sheet within a Workbook?

And I am using VB editor to enetr the code - is this correct?

Again, many thanks.

Thanks. Do I use this as a formula or a macro? Where should I enter this?

Your help is very much appreciated.

Sorry, exit and close an entire workbook

How can I make users NOT exit an excel form without certain cells being filled in?

Thanks.