VB and VBA Users Source Code: Re: Copying data between Excel Ranges

VB/VBA Source Code
Re: Copying data between Excel Ranges

By:	Dan Odom
Email (spam proof):	Email the originator of this post
Date:	Saturday, December 06, 2003
Hits:	1453
Category:	VBA (Visual Basic for Applications)

Article:
This code was very helpful in the project that I am currently working on, but I have a few questions. Once you have copied and pasted the contents of one range to another range, is there a way using VBA code to automatically drop down to the very next cell in a column if the cell above it has data in the cell? I have about 4 workbooks that are copying and pasting info to one another and on two of them the info get pasted at the end of each day. And I need it to automatically go to the very next cell before the next day's information is pasted. And I also have to figure out how to have VBA recognize when the month is over and to start fresh every month. ANy help would be appreciated greatly, Thanks again Dan Odom
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder