for each cell in Activesheet.UsedRange

Next

--
Regards,
Tom Ogilvy

"Neil" wrote in message
...
Hello All,

I have an excel workbook which has some fields set as the £ currency
format.
I would like to be able to programatically loop through all active cells
in
each worksheet - check to see if the format is pounds and then change them
to say ? or $ if required. I know how to do everything except for looping
through the cells.

Is there any way of getting the Active Cell range for a worksheet?

The only way i can do it at the moment is loop through all cells (which
would take a LONG time) or loop through a set number of cells that i
specify - the only problem with doing this is if a user was to insert more
rows and the rows go outside the set range then these cells are not
updated.
I am sure i am missing something so simple...

Any help is greatly appreciated,

Neil.