VBA Looping and Printing

**stevow** · 11-17-2009, 09:22 AM

Hi

Firstly thanks for any help given.

Requirement:

VBA to search a vertical range (B2:B21) for any cells that are not blank, then copy/paste the number to another cell on a seperate worksheet called "NewForm" and cell (C25), then print this form. When sent to printer it needs to find the next number in the next cell and repeat process until the next cell is blank.

I have the below, but this copies and pastes the first two entries below each other on NewForm rather than in the same cell (C25)... Any thoughts/solutions?

Notes: The range is always the same, the destination is always the same and there can be between 1 and 20 entries in the range.

Please Login or Register  to view this content.

**JBeaucaire** · 11-17-2009, 11:59 AM

Hi Stevow. Welcome to the forum.

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above and put code tags around that code you used. (Like I did below...)
============

Please Login or Register  to view this content.

**stevow** · 11-17-2009, 12:54 PM

Great stuff!! All perfect!!

I changed the code as requested, thanks for the rule set for me to adhere to.

**JBeaucaire** · 11-17-2009, 02:36 PM

Awesome, glad to help! Come back for more, maybe you'll have the answer to someone else's question?

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)