Determine last col with data

I

ian

Need a macro to determine the last col to the right(blanks in between) anc
copy last col to sheet1
Thanks
 
I

ian

Sorry for the misunderstanding.
I need a macro to find and copy the last col on a worksheet(There will be
blanks between Col A and the last col on the right
 
R

Ron de Bruin

See the link I posted there you can see how you can use the
function result in your macro.
 
Top