Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 425
Default fill down range starting at last cell

This code works.

Now I need to....

add fill down adjacent to the last row used in column F from this
point.
(G4:L4 contains formulas)

Range("G4:L4").Select
Selection.Copy
Range("G65000:L65000").Select
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,533
Default fill down range starting at last cell

Hi

Try this:

LastRow = Range("F" & Rows.Count).End(xlUp).Row
Range("G4:L4").AutoFill Destination:=Range("G4:L" & LastRow)

Regards,
Per

"J.W. Aldridge" skrev i meddelelsen
...
This code works.

Now I need to....

add fill down adjacent to the last row used in column F from this
point.
(G4:L4 contains formulas)

Range("G4:L4").Select
Selection.Copy
Range("G65000:L65000").Select
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default fill down range starting at last cell

hi
this might work also...
Dim gc As Long
Dim fc As Long
gc = Cells(Rows.Count, "G").End(xlUp).Offset(1, 0).Row
fc = Cells(Rows.Count, "F").End(xlUp).Row
Range("G1:L1").Copy
Range("G" & gc & ":G" & fc).PasteSpecial xlPasteAll

regards
FSt1


"J.W. Aldridge" wrote:

This code works.

Now I need to....

add fill down adjacent to the last row used in column F from this
point.
(G4:L4 contains formulas)

Range("G4:L4").Select
Selection.Copy
Range("G65000:L65000").Select
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 425
Default fill down range starting at last cell

THANX!
Reply
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
Select range starting at active cell standard_guy Excel Programming 5 January 5th 09 08:30 PM
Change the starting and ending cell of a dynamic named range Arlen Excel Discussion (Misc queries) 2 August 8th 08 01:53 PM
Auto fill numbers starting with zero pianogirlny Excel Discussion (Misc queries) 3 December 31st 07 04:15 PM
How can I assign a range starting cell based on a variable locati. feman007 Excel Discussion (Misc queries) 1 March 10th 05 12:41 AM
How can I assign a range starting cell based on a variable locati. feman007 Excel Worksheet Functions 3 March 10th 05 12:40 AM


All times are GMT +1. The time now is 07:51 PM.

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

About Us

"It's about Microsoft Excel"