+ Reply to Thread
Results 1 to 2 of 2

Excel macro, editing recorded cell.. not current

Hybrid View

Guest Excel macro, editing recorded... 01-12-2006, 09:10 AM
Guest Re: Excel macro, editing... 01-12-2006, 09:30 AM
  1. #1
    TroyT
    Guest

    Excel macro, editing recorded cell.. not current

    So I recorded a Macro... and I want it to be able to edit values next to the
    current cell, not the ones i recorded the macro on.

    here is the macro file..


    Range("K3").Select
    Selection.Insert Shift:=xlDown
    Range("K3:L3").Select
    With Selection.Interior
    .ColorIndex = 6
    .Pattern = xlSolid
    End With
    Range("I4").Select


  2. #2
    Tom Ogilvy
    Guest

    Re: Excel macro, editing recorded cell.. not current


    ActiveCell.Offset(0,1).Insert Shift:=xlDown
    With ActiveCell.Resize(1,2).Interior
    .ColorIndex = 6
    .Pattern = xlSolid
    End With


    --
    Regards,
    Tom Ogilvy


    "TroyT" <TroyT@discussions.microsoft.com> wrote in message
    news:1BE5EF12-44C3-474A-9325-3AAF637D024E@microsoft.com...
    > So I recorded a Macro... and I want it to be able to edit values next to

    the
    > current cell, not the ones i recorded the macro on.
    >
    > here is the macro file..
    >
    >
    > Range("K3").Select
    > Selection.Insert Shift:=xlDown
    > Range("K3:L3").Select
    > With Selection.Interior
    > .ColorIndex = 6
    > .Pattern = xlSolid
    > End With
    > Range("I4").Select
    >




+ Reply to Thread

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