Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to standard module
I have a .xlt with 2 macros in it.
The .xlt is copied in code from Access to a .xls and then data is transferred from Access to the .xls Both of the macros are activated on click of seperate command buttons. The command buttons are in Sheet1 (Code) the sheet name is "Summary" Macro 1 runs fine but I am getting an error on the 2nd as below. Private Sub CommandButton2_Click() Dim FirstRow As Long Dim LastRow As Long Dim iRow As Long With Worksheets("Summary") FirstRow = 2 LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row + 1 End With For iRow = FirstRow To LastRow Next iRow Range("A" & iRow).Select ActiveCell.Value = "Assets" ActiveCell.Font.Bold = True ActiveCell.Font.Size = 12 Sheets("Assets").Select ERROR HERE Run-time error 1004 select method of range class failed I have discovered thanks to usergroup that this needs to be in a standard module. Can someone tell me how I do this and then how do I call it. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro in excel to call a access module to run. | Excel Discussion (Misc queries) | |||
Assigning a module to a button macro | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
How do I copy a new module to 200 workbooks with a macro? | Excel Worksheet Functions |