I am trying to copy the data in two columns to a new sheet in the same workbook. The size of the columns can change. One column is called "Data" and the other is called "Schedule". I will be importing the data from "Data" to "Schedule". Here is what I tried earlier for just column A, but it did not work.
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
Sheets("Data").Cells(A,FinalRow).Copy
Sheets("Schedule").Range(A2).Paste
Any suggestions? Thanks.
Try:
Dom
Please Login or Register to view this content.
Last edited by Domski; 02-01-2010 at 10:03 AM. Reason: Code correction
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I just tried that and I am getting an error 400 message.
Small correction:
DomPlease Login or Register to view this content.
That worked perfectly! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks