How to simplify the VBA code from function to send rows into send range

[herukuncahyono]

Hi,
I have a code where the function is to send a certain amount of data from a single rows value from one sheet to another sheet by name in a specific cell.
my question is whether function can be simplified if we want to send 2 or more rows because this is the appropriate code below just to send the value from the 2 rows on the 8 column value
And will become a long code if we want to send 50 rows

Please Login or Register  to view this content.

If the code "send ROWS value from one sheet to other in the next blank row" how if simplified to " send RANGE value from one sheet to other in the next blank row"
Thanks for the help

[HaHoBe]

Hi, herukuncahyono,

maybe try it like this (untested):

Please Login or Register  to view this content.

I doubt itīs a good idea to have On Error Resume Next in the code.

Ciao,
Holger

[herukuncahyono]

Hi Holgar,
After I try it on the sheet ,works as I wanted ... thank you

regards