WebGuy
05-15-2006, 12:20 AM
Hi!
Since i am very new to VB my knowlege is very limited. I have however managed to use vb to script a few helpful programs(mainly sort& select routines).
My question is regarding one of my sort & select routines. My script adds, subtracts, multiplies and summarizes thousands of values in 3 different sheets. This means that there is a lot of jumping between sheets. I an trying to find a way to do all the sheet jumping and calculating in the background while only showing the main sheet. Does anyone know if this is possible.
//Henry VBRookie
Since i am very new to VB my knowlege is very limited. I have however managed to use vb to script a few helpful programs(mainly sort& select routines).
My question is regarding one of my sort & select routines. My script adds, subtracts, multiplies and summarizes thousands of values in 3 different sheets. This means that there is a lot of jumping between sheets. I an trying to find a way to do all the sheet jumping and calculating in the background while only showing the main sheet. Does anyone know if this is possible.
//Henry VBRookie