VBA Offset and Transpose

Hi, I wonder whether someone may be able to help me please.

I'm using the code below to perform the following:

• Find the last used row in column B starting at row 8,

• When this is found offset 8 rows, then

• Add certain text values from an array

Please Login or Register  to view this content.

The problem I'm having is that when I run the code, only the first text value in the array (i.e. in the .offset (8,0) position) is shown. The remaining text values in the array are not displayed.

I just wondered whether someone may be able to look at this please and let me know where I'm going wrong.

Many thanks and kind Regards

Please Login or Register  to view this content.

?

Hi @jindon, thank you for taking the time to reply to my post.

The solution you suggested works great.

All the best and kind regards