Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro do works in excel...
Hi again,
How to write in this code by 1) making the workbook to be set in Manual Calc. mode, before population of template sheets, 2)after population of the sheets, return back to Automatic calc mode. here's the wonderful <guided typical code from Sir Toppers ---------- Sub SetUp() Dim ws1 As Worksheet, ws2 As Worksheet, ws3 As Worksheet, ws4 As Worksheet Dim irow As Long, orow As Long Dim Lastrow As Long Dim wsname As String Set ws1 = Worksheets("LIST") Set ws2 = Worksheets("TEMPLATE") Set ws3 = Worksheets("CAT") Set ws4 = Worksheets("DATA") With ws1 Lastrow = .Cells(Rows.Count, 1).End(xlUp).Row For irow = 2 To Lastrow wsname = .Cells(irow, 2) Sheets("Template").Copy After:=Sheets(Sheets.Count) ActiveSheet.Name = wsname ActiveSheet.Range("H1") = wsname .Cells(irow, 33).Formula = "='" & wsname & "'!h54" .Cells(irow, 34).Formula = "='" & wsname & "'!h53" .Cells(irow, 35).Formula = "='" & wsname & "'!h52" .Cells(irow, 36).Formula = "='" & wsname & "'!h51" .Cells(irow, 37).Formula = "='" & wsname & "'!h50" .Cells(irow, 38).Formula = "='" & wsname & "'!J9" .Cells(irow, 39).Formula = "='" & wsname & "'!C53" .Cells(irow, 40).Formula = "='" & wsname & "'!C52" .Cells(irow, 41).Formula = "='" & wsname & "'!C51" Next irow End With End Sub --------- thanks for help, driller -- ***** birds of the same feather flock together.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email Macro only sometime works? | Excel Discussion (Misc queries) | |||
Excel macro works only for administrator | Excel Discussion (Misc queries) | |||
Tab-naming macro only works once :-( | Excel Worksheet Functions | |||
macro works for some users and doesn't for others | Excel Discussion (Misc queries) | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) |