Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

End(xlDown). Question in Excel

Posted on 2013-10-31
3
Medium Priority
?
637 Views
Last Modified: 2013-11-01
Hi Guys, I have a simple copy and paste Macro that copies a Formula in the Range ("S3") and copies that Formula down. The problem is I need it to go down as far as the last row in Column D. How do I do that?


Worksheets("Rec").Select
Range("S3").Copy
    Selection.Copy
       Range(Selection, Selection.End(xlDown)).Select
    ActiveSheet.Paste
0
Comment
Question by:Justincut
  • 2
3 Comments
 
LVL 53

Expert Comment

by:Rgonzo1971
ID: 39613739
Hi,

pls try

Worksheets("Rec").Range("S3:S" & Range("D" & Rows.Count).End(xlUp).Row).FillDown

Open in new window

Regards
0
 

Author Comment

by:Justincut
ID: 39613966
Does "FillDown" mean paste?

Range("S3").Select

 
    Range("S5:S" & Range("E" & Rows.Count).End(xlUp).Row).FillDown

   

    ActiveSheet.Paste
0
 
LVL 53

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39614240
Hi

Filldown is like grabbing the square at the bottom right of the cell to copy the content downwards

it is another way to copy and paste adjacent cells

if you want to copy in another region pls use

Sheets("rev").Range("S3").Copy Destination:=Sheets("rec").Range("S5:S" & (Sheets("rec").Range("D" & Rows.Count).End(xlUp).Row))

Open in new window


Regards
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question