copy column
 

Hey Everyone,

I appologize in advance for this newbie question.

I have been reading alot on the web and I haven't found out how to do
this.

I need to write a script that will select the last column in a sheet
and then copy that to the next column. I have to run this frequently,
so I cant just select the column unfortunatly. I also need to do it for
rows, but once i see it for columns, I hope can figure that out. Any
help would be GREATLY appreciated!

Thanks,
Kunal

copy column
 

Are you looking for the last column with data in it? or are you lookin
for a column containing specific text? A little more info about wha
you want it to do, and I can help you write a macro for it..

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=48233