Determine last col with data

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

Need a macro to determine the last col to the right(blanks in between) anc
copy last col to sheet1
Thanks
 
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
 
See the link I posted there you can see how you can use the
function result in your macro.
 
Back
Top