LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?










 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i change this VBA project According to Indian Numeric Rao Ratan Singh Excel Discussion (Misc queries) 1 April 21st 05 07:53 PM
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM
Change rows to columns and vise versa Ian Johnson New Users to Excel 2 March 4th 05 02:24 AM
select drop down list 1 value will change the value in dr... Vincent Excel Worksheet Functions 1 February 3rd 05 11:52 AM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 AM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"