View Full Version : ref the activecell value in an inactive sheet
drawworkhome
02-10-2010, 07:15 PM
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
02-10-2010, 07:17 PM
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
02-10-2010, 07:26 PM
If you activate it you can use activecell:
Workbooks("Book1").Activate
drawworkhome
02-10-2010, 07:34 PM
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....
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.