Cut and paste macro



I need a macro that will cut the data in a specific range of cells in
a column and paste it to the column immediately to the right of the
last column containing data. I have been able to accomplish the cut
and paste bit but it is pasted over the last column of data rather
than being next to it. I can't simply specify the range of cells
because this needs to be able to grow, so that it would continue to
paste NEXT to, on the right of, the last column of data, regardless of
how many columns there may be. Please help!! I'm kind of in a hurry!!

Don Guillett

Details and your code and examples of before/after. something like this
range("c:???").cut range("c"&lc)

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question