LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Replacing cell ref with active cell

In this recorded macro, I go to Cell A1001, select it, drag the fill
handle to the cell below.

Q: How can I edit the macro to select the active cell and go down one
row, instead of the exact cell values in the brackets after Range?
(newbie question) Is there a syntax similar to:

Range(Activecell).Select
Then
Range("Activecell:ActiveCell+1)

???

--- recorded macro ---
Application.Goto Reference:="R1001C1"
ActiveWindow.SmallScroll Down:=3
Range("A1001").Select
Selection.AutoFill Destination:=Range("A1001:A1002"),
Type:=xlFillDefault
Range("A1001:A1002").Select
--- end of recorded macro ---

thanks in advance
PUBA

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row select mode to highlight active row of active cell Bart Fay[_2_] Excel Discussion (Misc queries) 0 May 11th 10 09:34 PM
Replacing Input Box in Macro with Info Picked Up from Active Cell? Wart Excel Discussion (Misc queries) 3 August 14th 08 08:45 PM
referring to formula in a non active cell from active cell nickname Excel Discussion (Misc queries) 1 June 21st 07 12:11 PM
Replacing value in cell with answer of same cell Flying_Dutcman Excel Worksheet Functions 1 July 21st 06 09:33 AM
I need to sort an active sheet using the col of the active cell HamFlyer Excel Programming 3 June 6th 06 07:25 PM


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"