View Single Post
  #7   Report Post  
Daniel
 
Posts: n/a
Default

my plan was to throw a workbook minimize before all the code then a work
book mazimize after the code but it seems that i have to go through and
replace all my foo.select with direct access such as
Worksheets(1).Range("A1:A10").Value = 25

"Ron de Bruin" wrote in message
...
Selecting is Ok
It is working but it slow down your macro.

I don't matter if you have Excel minimized or not.
Do yave you problems with your code when Excel is minimized ?


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Daniel" wrote in message

...
ok but if i already have lots of code that selects values it would have

to
be rewritten if i were to do it all minimized?

"Ron de Bruin" wrote in message
...
You don't have to select cells to chnage the values

This is working for example for the activeworkbook

Worksheets(1).Range("A1:A10").Value = 25

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Daniel" wrote in message

...
is it possible to select and change the values of cells in a

minimized
excel
spread sheet from vba?