I know this may be a crazy question but....

C

CLamar

I have code where i have to activate the sheet in order for the code
correctly. Now, I dont want that sheet to be displayed because it slows down
the macro. Is there a way to either Activate the sheet and not have it
displayed or another way to disable screen updating besides
Application.ScreenUpdating = False cause that doesnt work

thanks
 
D

Dave Peterson

There are very few things that depend on the activesheet.

I think I'd try to rewrite the code that depends on the activesheet.

And I've never seen .screenupdating fail. I have seen it turn on when I used
something out of the Analysis toolpak (IIRC). But since I can't control that,
I'll just add another .screenupdating = false to freeze it when the ATP call
finishes.
 
C

CLamar

Do you have any suggestions for not having the sheet active in order to
proceed with the code. When I dont make the sheet active it gives me the
error "Method 'Range' of object Global failed". Here is an example of the
code:
The error occurs at the line beginning with newfbr when i comment out the
Sheets("Plotdata").Activate line

Do Until oldfbr > LastCellVRH1x
Sheets("AreaSolver").Range(PS.Cells(8, 1), PS.Cells(36, 6)).Clear
'Sheets("PlotData").Activate
With Sheets("PlotData")
top = oldfbr
newfbr = Range("F" & oldfbr & "").End(xlDown).Row
bottom = newfbr
oldfbr = newfbr + 3
SerialName = Sheets("Sheet4").Range("E" & i & "").Value
ChartTitle = Sheets("Sheet4").Range("C" & i & "").Value
TestMethod = Sheets("TestTable").Range("I" & i + 1 & "").Value
AreaLabel = Sheets("Sheet4").Range("E" & i & "").Value & " / " & _
Sheets("Sheet4").Range("D" & i & "").Value
 
Top