Results 1 to 2 of 2

losing my formula in macro

Threaded View

amesatlast losing my formula in macro 03-04-2005, 09:26 AM
amesatlast Hope the additions help 03-04-2005, 12:16 PM
  1. #1
    Registered User
    Join Date
    02-25-2005
    Location
    Branchport,NY
    Posts
    5

    Question losing my formula in macro

    I have a subtotals page and I am filtering my information. After the filter i insert a formula and copy it down to the end of my information. I then remove the filter. Finally I Click the level two button. When I run the macro the formula stage gets lost. No formulas are getting entered.

    When I traced this progam it isn't entering my formulas. Can anyone help me?
    Sub Part3_Platy()
    '
    ' Part3_Platy Macro
    ' Macro recorded 3/4/2005 by employee
    '

    '
    Selection.AutoFilter
    Selection.AutoFilter Field:=1, Criteria1:="0 Count"
    Range("A3").Select
    ActiveCell.FormulaR1C1 = "=R[-1]C[2]"
    Selection.FillDown
    Range("A1").Select
    Selection.AutoFilter Field:=1
    Columns("C:C").Select
    Selection.EntireColumn.Hidden = True
    Columns("A:B").Select
    Columns("A:B").EntireColumn.AutoFit
    ActiveSheet.Outline.ShowLevels RowLevels:=2
    End Sub
    Last edited by amesatlast; 03-04-2005 at 12:14 PM. Reason: added macro

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1