Hi Mark

You can use a function Lastcol

See the example on this page
http://www.rondebruin.nl/copy1.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mark Vandenberk" wrote in message
...
Is there code or a formula that will return the last column with text in it?

I want to copy the same 5 columns into the LAST column of the worksheet. I
would like to do this repeadetly, so the last column would change.

Any suggestions?