| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
is it possible to select and change the values of cells in a minimized excel spread sheet from vba?
is it possible to select and change the values of cells in a minimized excel
spread sheet from vba? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
yah the code that selects cells and such fails if the sheet is minimized
"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? |
|
#6
|
|||
|
|||
|
well i mean if the whole workbook is minimized.
"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? |
|
#7
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| Change rows to columns and vise versa | New Users to Excel | |||
| select drop down list 1 value will change the value in dr... | Excel Worksheet Functions | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Linear Mode
