Unsure of correct reference for named range.

[JohnDoh]

Hi all,

Thought I had this one sorted but no.

I'm using a macro to automatically create and send an email after a certain event in a cell.

The code works fine if im in the sheet and the event is triggered, but if I edit data in a different sheet which then causes the event to trigger the macro the code gets stuck here.

Please Login or Register  to view this content.

I have tried a few things, like adding sheetname! in front of the cell references , but soon realised I do not know how to name a range on a specific sheet

[Jack7774]

Do you mean like naming the range of cells from A1:G50 say like "Rawdata" in the name manager under tab Formulas?

[Arkadi]

John,
If I understand correctly, your range("A1:G50") needs to be selected on the same sheet regardless of which one is active? have you tried changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

NOTE: you need to activate the sheet to select from it, so add "Worksheets("Sheet1").activate" above the line in question if using this method.

[walruseggman]

Do you mean something like this? Where Sheet1 is the name of the sheet.

Please Login or Register  to view this content.

[JohnDoh]

Sort of, I have just notice I missed a bit in my first description, the macro creates a .pdf file with that range as the print area, so if I'm in another sheet it creates a pdf of the wrong sheet.

So I guess I'm trying to work out if sheetname!A1:G50 is not the right way to go what should I name it as to pick up the same sheet regardless of whether I'm in the right sheet or not.

[JohnDoh]

Ignore the last post, was typing it while you lot were busy solving it.

Thats exactly what I meant.

Thank you all.