copy & paste last 10 visible values

**Meena_Sassati** · 01-13-2016, 09:06 AM

hello friends

I want to copy last 10 visible values of column A. i have below macro, can anyone help me.

Please Login or Register  to view this content.

Thanks in advance.

**Meena_Sassati** · 01-13-2016, 09:21 AM

i tried Lastrow - 9, but not working

**JOHN H. DAVIS** · 01-13-2016, 10:41 AM

This is probably not very helpful, but maybe:

Please Login or Register  to view this content.

**Meena_Sassati** · 01-18-2016, 06:40 AM

Not Working.....

**JOHN H. DAVIS** · 01-18-2016, 08:48 AM

Can you attach a sample file showing a page before the macro is run and a page showing the result that you want?

**Meena_Sassati** · 01-18-2016, 01:15 PM

Hi John

Happy New Year...!!

Thanks for valuable time, the sample workbook is attached for your reference.

Thanks

Re: copy & paste last 10 visible values