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.
 

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

Similar Threads

Macro to hide cols 2
macro to find bottom of column 5
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
CONCATENATE code 2
Sub to freeze cols up to extent of data in col Q 6
VBA to run all variable combinations in a calculation model and store result 6
looking across a row for certain data 7
Sub to carve out uniques based on col header whose position may va 6

Top