Excel+macro: Print based on range values

[HugoSilva]

Hello I'm having some difficult to find the right code for the following goal:

I have a sheet with a macro that when i change a value in the cell E5, automatically fill certain fields in sheet1, searches and return values from a table on other sheet - sheetTable). So after changing cell E5, sheet1 is basically ready to print.

My goal is to select a range of values in a collumn on sheetTable and assign each one of them to Cell E5 on sheet1, and print each one.

So lets say I select 3 cells with values: 45, 50 and 66. When I run the macro it will assign 45 to cell E5 and print sheet1, then it will assign 50 to cell E5 and print sheet1 and finally will assign 66 to cell E5 and print sheet1.

Also, I need to print each ones in PDF and the resulting PDF filename should be the value of E5 cell [basically something like range(e5).value.pdf].

Can anyone help me plz?

[JBeaucaire]

Seems like this should do it, with some edits on your part:

Please Login or Register  to view this content.

[HugoSilva]

Hi. Thanks for the help but there is something wrong on the code...
it returns me run-time error '438' on line

For Each cell In ActiveSheet.Selection

[JBeaucaire]

Maybe, assuming the sheet with the selected cells are onscreen:

Please Login or Register  to view this content.

[HugoSilva]

All done! Thank you for your help