Copy specific cells in a row to an array and then display them

[Macster]

Me again,

I want a macro that if a certain cell on a row in column F on my worksheet is "6" then copy the cell in columns B and H on the same row are to be copied into an array and then when the loop is done, display the copied cells in a msgbox.

Is there a simpler way to do this without fidgeting with an array?

Thanks in advance
Macster

[Macster]

I had a browse through the archive here and found an old code from Leith which I tried to change accordingly

Please Login or Register  to view this content.

The box comes up blank though..

[ravishankar]

HI
try these codes

Please Login or Register  to view this content.

Ravi

[royUK]

Is this what you need?

Please Login or Register  to view this content.

[Macster]

Excellent! Many thanks!

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved and rate the replie(s) using the scales icon. It's also nice to know which solution you used.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save