How to apply multiple Range to refer multiple worksheets in VBA

[DURGESH88]

Hi Team,
I have used below code to generate the email. Currently I am able to take data from only one sheet and code is working fine. Now I would like to take the pieces of data multiple sheets, then how I can modify the code?

Set Sendrng = Worksheets("Reporting").Range("A6:N203") ' This is the line from where I am taking data from only current worksheet.

Can you please help me on this. Thanks!

Code:

Please Login or Register  to view this content.