Below is my the macro that I recorded. I want to copy and paste the same information to a new location everytime. The macro tells it to go to cell IV1, end left, then I want it to go right one cell regardles of the cell location. Here it tells it to got to ("K1"). It will do this everytime and I do not want it to go to K1, just move right one time and then paste the information.
Any Help will be appreciated
Please Login or Register to view this content.
Last edited by Excel Wanna Be; 03-30-2009 at 02:44 PM.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
I am a bit confused
Right after code line "Selection.End(xlToLeft).Select" I want to move right one cell. What code do I enter where this once was "Range("K1").Select"
ThanksPlease Login or Register to view this content.
Replace
With the two lines of code I posted.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks