Ctrl+A will select all cells so you should be able to use
cells.select
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

how do you simulate pressing CTRL and A at the same time? would you use the
SendKeys method? If so I am not sure of the code? If not, any ideas?

thanks in advance,
geebee