ref the activecell value in an inactive sheet

[drawworkhome]

hi,
is there a way to use activecell to reference the value of the selected cell in a sheet that is not current in the activeworkbook? from all i can find, it cant be done but it seems to me that there should be a way to make it work.
thanks erik

[lucas]

Well, if it's not the current activeworkbook it would hard for it to be the active cell.

What are you trying to do?

[lucas]

If you activate it you can use activecell:

Workbooks("Book1").Activate

[drawworkhome]

well, what i am trying to accomplish is this:
the user selects a cell on sheet1 and changes its value. using the sheet1 worksheet change event, i create a subfolder with that cells value from a module called jobsetup.createsubfolder
should i place the createsubfolder code into the sheet1 worksheet change event code? i probably just answered my question....