• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

Copy value of active cell down, as long as there is a value in column E

Title of question is it.  I have a active cell with a value that I need to copy down that column as long as there is a value in column E.  There will always be a value in column E, but it does not go down the whole dataset, only part of the way.

Active cell is column B,  how do I tell it to check offset 3 columns to the right and figure out how many contiguous cells with data, (xlDown) there is from there down, so I can copy then copy my original active cell down that many times?

Then ending on the offset 3 to the right of original cell?
0
RWayneH
Asked:
RWayneH
  • 3
1 Solution
 
NorieCommented:
Try this.
ActiveCell.Copy Range(ActiveCell, Cells(Rows.Count, "E").End(xlUp).Offset(, -3))

Open in new window

0
 
RWayneHAuthor Commented:
Worked but it copied it down, one past the bottom, so it added one.  Can we reduce that by one?
0
 
RWayneHAuthor Commented:
Never mind after test it further it worked.  Thanks.
0
 
RWayneHAuthor Commented:
Thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now