Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a problem where I've recorded many macros within a workbook and
I am trying to consolidate them so the workbook wont be so large and have so many macros. Instead of doing it this way: Sub MainMacro() run macro 1 run macro 2 run macro 3 End Sub I began actually copyingt the codes and combining them. The problem I get is when I run the final macro, I have to go back and put a number in front of some commands like "Rng" & "String" to avoid the "compile error: duplicate declaration in current scope." Example code: Dim Rng As Range, cell As Range Dim s As String, s1 As String Dim sChr As String, i As Long Set Rng = Range(Cells(1, 1), Cells(Rows.Count, 1).End(xlUp)) For Each cell In Rng Any suggestions on combining macros? Or to avoid this particular error? I sure hate going back trying to number each to separate them. Thanx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicate declaration in scope | Excel Programming | |||
Running macros it returns compile error in hidden module | Excel Programming | |||
Macro / Compile Error / Duplicate Declaration | Excel Worksheet Functions | |||
duplicate declaration | Excel Programming | |||
Compile error for macros | Excel Programming |