Results 1 to 3 of 3

inserting row using macro

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2009
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    58

    inserting row using macro

    Hi I"m toally new to Macros...I'm trying to record a macro to insert rows using the following, but it's not copying the formulas in some cells...
    I've added a radio button and assigned the macro, but it seems to add a blank row without filling down with the formulas from the cells above. Can anyone help with what I need to change to make sure the inset row picks up formulas from row above?
    Range: A to Y
    I'm trying to get the macro to add rows above the "radio button" i created on the last cell. The formulas in some cells pickup data entered in other worksheets within the same workbook.

    I'm using:

    Sub InsertRow()
    Activecell.EntireRow.Insert
    Activecell.Offset(0,0).Value=""
    End Sub
    Looking forward to any help!

    Thanks,
    Last edited by Dannypak; 03-18-2009 at 02:10 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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