Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am getting the "Compile Error: Expected Variable or Function" when I try to
run the following: Sub Belknap() ' ' Belknap Macro ' Macro recorded 10/28/2004 by Tina Ware ' ' Keyboard Shortcut: Ctrl+b ' ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Belknap").Select cells.Select Range("C1").Activate Selection.ClearContents Sheets("GOOD ONE").Range("p1:bw2449").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheets("Counties").Range("A2:c3"), CopyToRange:=Range("A1") _ , Unique:=False ActiveWindow.SmallScroll ToRight:=9 Columns("O:bg").Select Selection.Delete Shift:=xlToLeft Range("A1").Select End Sub I have used this command before, and actually recorded the macro again and I still get the same error when I try to run it!!!! Help please, MMM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Solving for X and Y with a = in the FUNCTION??? | Excel Discussion (Misc queries) |