PDA

View Full Version : Transfer row from list box to another sheet VBA



prospice
02-15-2017, 06:20 PM
Need help I need to TRANSFER data totally from listbox, meaning if i transfer the data from sheet 1 to sheet 2 the transfer data must not be visible on the sheet 1 just like cut and paste?

Thanks you!

Regards,
Russel

Please see attached file

SamT
02-16-2017, 01:53 PM
Listbox1.TopIndex relates directly to Sheet1 Row number . . so Sheet1.Rows(Listbox1.TopIndex + 1).Delete