selection range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have the following:
Range(Selection, Selection.End(xlDown) - 1).Select
Selection.FillDown
Selection.End(xlDown).Select

This is selecting everything to the next value in a list (I then filldown).
Need it to go to the value and then subtract 1 row from the range (so the
filldown does not overwrite the next value in the list).

Thanks.
 
Maybe...

Range(Selection, Selection.End(xlDown).offset(-1)).Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File Name changes with dates and Deleting Rows of Zeros 0
Please help combine two simple codes! 3
Macro to fill to next field with data 4
On error goto specified Line 6
Fill Down to Stop at Last Row 4
Excel Macro to use cells as a autofilter 0
How to use a variable as an argument in .FliiDown 4
VBA Copying/Pasting problem when data is filtered 1

Back
Top